| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to count unique entries with multiple condition
A B
china P1 korea P2 japan P3 china P2 korea P2 japan P1 U.S P2 India P1 China P1 U.S P2 I'm working with about 8000 data, I try to used this formula =SUM(IF(FREQUENCY(MATCH(A1:A10,A1:A10,0),MATCH(A1: A10,A1:A10,0))0,1)) to count the unique entries in column A, which result 5. (China, japan,korea,india,U.S) However, i want to count unique entries in, let say P1 only, which should be 3. How to use function to get this result? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| Count Unique Values | Excel Worksheet Functions | |||
| Count Unique in Pivot Table | Excel Discussion (Misc queries) | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
| compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
Threaded Mode
