I have a User input text field, based on which a table is populated.
I'm interested in one column (with column name 'Parts-subcomponent mapping') of the table. The 'Parts' column can have Null values or can hold Part name. Parts are mapped to a subcomponent.
I want to pick the top 30 rows of the table that have data (i.e. not NULL) in Parts.
Then perform a group by on subcomponent names, and filter the results of the Parts table using the subcomponent that appears most frequently.
What are the ways in which I can do this?
More details in the sample workbook with dummy data.
4 answers
Hello @Jim Dehner , I've provided a sample workbook with dummy data. i hope it clarifies what i'm looking for.
Null in parts means no part was replaced in that instance
