Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting unique items within categories - but EXCLUDING blank cell
Good morning!
About a week ago, I received an amazing formula on this website, for counting the number of unique items within different categories. Specifcally, my problem was: ITEM CATEGORY apple A apple A bannana A bannana B bannana B So I wanted Excel to figure out that there are 2 unique items in Category A ("apple" and "bannana"), and only one in Category B ("bannana"). The solution I was given was: =SUM(IF(FREQUENCY(IF(CategoryRange="Category",MATC H"~"&ItemRange,ItemRange&"",0)),ROW(ItemRange)-MIN(ROW(ItemRange))+1),1)) This is a fantastic solution and it works perfrectly - except that it also counts blank cells as a unique entry, too! Is there a way to keep Excel from counting blank cells as a unique item in each category? Thanks again for the help you guys are providing on this amazing website!! -Brett |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting unique items within categories | Excel Worksheet Functions | |||
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 | Excel Discussion (Misc queries) |