| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count once, multiple duplicate values?
I have the following sheet
Container sub-Container Volume %used Name1 Sub1 100 60 Name1 Sub1 100 80 Name2 Sub2 100 30 Name3 Sub3 100 40 I want to count the Container column that exceeds 50%, but NOT duplicate values (so in the above example I should get 1 as the answer (Name1 is only counted ONCE even though there are two occurences of it exceeding 50%)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Duplicate Values | Excel Discussion (Misc queries) | |||
| How to count duplicate or repeat values | Excel Discussion (Misc queries) | |||
| Count duplicate cell values per month | Excel Worksheet Functions | |||
| Count on multiple values with duplicate rows | Excel Worksheet Functions | |||
| How do I do count calculations ignoring duplicate values | Excel Discussion (Misc queries) | |||
Threaded Mode
