Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi, I've run into a little problem that I can't seem to figure out...
I have two columns of data - one column contains a list of items, and the other contains one of three possible categories (A, B, or C) to which the items are assigned. Due to other considerations within my sheet, specific items may be repeated multiple times within the first column, and they may also exist in any combination of all three categories. My question is: Is there a way to summarize how many UNIQUE items exist within each of the three categories (i.e., the number of different items within category A, not including the repeats)? I've tried lots of versions of the countif and frequency function, but nothing has worked so far... thanks for your help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Unique Items with Multiple Criteria | Excel Worksheet Functions | |||
Counting Unique Items with Multiple Criteria | Excel Worksheet Functions | |||
Counting unique items...please help | Excel Worksheet Functions | |||
counting unique items(values or text) | Excel Worksheet Functions | |||
counting unique items | Excel Discussion (Misc queries) |