Count duplicates once

G

Guest

I need to count how many different codes/numbers are in a list, and some of
them are duplicated. eg:

300001600
300001600
300002465
300001435
300005642

I need the result to show that there are 4 different numbers, rather than 5
in total.
 
T

T. Valko

If the codes/numbers are strictly numbers:

=COUNT(1/FREQUENCY(A1:A10,A1:A10))

If they may be alphanumeric:

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

Biff
 

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

Counting number of items excluding duplicates. 1
Counting the number of different entries in a column 2
Problem not counting duplicates 1
Trying to construct a count count formula 6
Count 3
How can I count dates if few duplicates in a column 3
Counting strings of consecutive numbers in a column 1
Counting a list 6

Top