|
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! |
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! |
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 |
| All times are GMT +1. The time now is 04:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com