| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Unique Items
I want to count the unique items in a list where a related field matches
another criteria. For example, A B 1 orange bob 2 orange sue 3 orange hank 4 la ted 5 la ted 6 la ted 7 la joe 8 orange bill 9 orange deb 10 orange sue 11 orange bill I want to count how many unique people there are in Orange. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use SUM and FREQUENCY functions to count unique items | Excel Discussion (Misc queries) | |||
| Use SUM and FREQUENCY functions to count unique items | Excel Discussion (Misc queries) | |||
| Count unique items in range | Excel Worksheet Functions | |||
| Count unique items in groups | Excel Worksheet Functions | |||
| How do I set up a formula to count only unique items in a column? | Excel Worksheet Functions | |||
Threaded Mode
