Count only once

R

rexmann

Hi

Is there an option to count a record only once. What i mean is if the word
is repeated in the list it only counts it once. Exampl

London
London
Brimingham
Manchester
London

This would give a count of 3 (only including the London once)

Not sure if this is possible

Any help greatly appreciated

rexmann
 
D

Dave Peterson

One way:

=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))

(Adjust the range to match.)
 
Top