| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I count numbers without including the repeated values?
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count numbers without including the repeated values?
=SUM(IF(FREQUENCY(IF(LEN(A1:A100)0,MATCH(A1:A100, A1:A100,0),""),
IF(LEN(A1:A100)0,MATCH(A1:A100,A1:A100,0),""))0, 1)) With your list of names in A1 to a100. Entered as an array formula ctrl + shift + enter "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! |
|
#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 |
| Reply |
| 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 | |||
Linear Mode
