Results 1 to 6 of 6

Productsum: Highest Frequency Category, Specific Main Category, Frequency of Category

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-17-2012
    Location
    CA, USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365
    Posts
    163

    Productsum: Highest Frequency Category, Specific Main Category, Frequency of Category

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1