| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I count numbers without including the repeated values?
One way:
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")) Nelson wrote: Hi! How can I count numbers without including the repeated values? Just take a look at the situation: John Mary John Rose The count is equal to 4 but I whant it to be 3 because "John" is repeated. Thanks a lot! -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EULA | Excel Discussion (Misc queries) | |||
| How to Search, Count, Match and Post Values | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
| count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Threaded Mode
