Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Unique Values
I'm trying to count the unique values given several conditions, for example
in the example below, count the number of unique Item_num's that were sold on Wed during the Morning, which would return 2: A B C 1: Item_Num Day Time 2: 1 Wed Morning 3: 1 Wed Morning 4: 2 Thur Evening 5: 2 Thur Evening 6: 3 Thur Morning 7: 3 Thur Morning 8: 4 Wed Evening 9: 4 Fri Evening 10: 5 Wed Morning 11: 5 Wed Morning |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Unique Values with Multiple Criteria | Excel Worksheet Functions | |||
how to count unique values in excel based on multiple criteria | Excel Worksheet Functions | |||
count and display unique values | Excel Worksheet Functions | |||
count number of values between plus signs in addition calc | Excel Discussion (Misc queries) | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions |