How can I count numbers without including the repeated values?

G

Guest

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!
 
G

Guest

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a report 2
how do I Count repeating numbers in the previous column? 9
Count quantity of repeated items in a column 4
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Count 5
Count the Repeated values 1
Count only once 3
count 6

Top