I am wanting to list in Columns S, U and X the types of Defects of the fruit from most frequent to least frequent. Though, my attachment does not show it, I figured out how to display the frequency using the formula below for Columns T, V and Y.
=SUMPRODUCT((F2:F13=S1)*(G2:G13=S4))
S4 is referring to a value of "Taste" I entered in which gave the correct frequency of that particular defect of the fruit. The file is attached to this thread post. How would I go about finding and displaying the unique category "Defects" for a particular main category such as Apricots from most frequent to least frequent (listing each defect only once)?
An example would be, that the greatest defect is Insects. Insects woul be listed first with the number frequency of Insects defects displayed in the column to the right of this. Insects would not be a repeated category since it is already displayed.
Bookmarks