Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count unique values across two columns with multiple conditions
I have a large spread sheet and I want to know the total number of classes
for an area. Classes with the same title but at different HS need to be counted seperately. For Example: School Class Area John HS Algebra Math John HS Geometry Math John HS Genetics Science Jane HS Genetics Science Jane HS Accounting Business Jane HS Accounting Business Total Unique Math Classes = 2 Total Unique Science Classes = 2 Total Unique Business Classes = 1 Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter for unique values in multiple columns | Excel Discussion (Misc queries) | |||
Count unique values based on multiple criteria | Excel Discussion (Misc queries) | |||
Count Unique Values with Multiple Criteria | Excel Worksheet Functions | |||
how to count unique values in excel based on multiple criteria | Excel Worksheet Functions | |||
Advanced unique cell count with multiple conditions ... help! | Excel Worksheet Functions |