I am having issues with the code shown below.
![]()
Please Login or Register to view this content.
My problem is being able to use the original data (user input data) and transforming to show:
- The three fruits with the highest quantities to display the name of the most frequent to least frequent defects. The defects may be unique to a particular fruit but the excel file is just an example. So the constraints would be: to formulate and rank the defects using the original data (no referencing by adding additional tables)
- Display quantity of defects for each defect for the three fruits with highest quantities; the frequencies will always be listed from largest to smallest but the list order of defects may vary depending on their frequency (cells $R$1:$X$20)
Other criteria is that more data will always be added to the original data. It is semi-dynamic. The limit has never gone over 500 rows.
Bookmarks