| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count only once with multiple columns
I have two columns:
A B Cancelled ABC Company Cancelled ABC Company Active ABC Company Cancelled ABC Company Cancelled XYZ Company Cancelled John Doe Company Active The Smith Company So I want to return this: Cancelled 3 Active 2 Meaning that there are 3 unique values counted once that are "Cancelled" there are 2 unique values counted once that are "Active" Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter Multiple Columns on Multiple Criteria and count the last co | Excel Worksheet Functions | |||
| To count the data using multiple criteria in multiple columns | New Users to Excel | |||
| Count if Multiple columns | Excel Worksheet Functions | |||
| how to count one value or another across multiple columns? | Excel Discussion (Misc queries) | |||
| Count on multiple columns | Excel Worksheet Functions | |||
Threaded Mode
