counting number of unique entries in a list

M

mtw

Anyone know how to count the number of unique enties in a
column?
I have 26,00 lines. I have many duplicate valuesa and want
to count only the unique ones.

example

123
321
456
123

In this case my count would be 3.

I know I can sort or filter but I still end up having o
manully count all the unique entries and I needit to be
dynamic.
Thanks
 
G

Gerry Kuta

=SUMPRODUCT((A1:A4 said:
-----Original Message-----
Anyone know how to count the number of unique enties in a
column?
I have 26,00 lines. I have many duplicate valuesa and want
to count only the unique ones.

example

123
321
456
123

In this case my count would be 3.

I know I can sort or filter but I still end up having o
manully count all the unique entries and I needit to be
dynamic.
Thanks
.
Click to expand...
 

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

count unique in one column based on two other columns 4
Count Unique accross mulitple columns 3
Counting unique entries in a field 5
Duplicates-to id when occurs in 3 columns for unique dup in 4th co 1
Counting Values 6
count unique values with auto-filter on 6
How to filter unique entires in a column when differnet entires in 13
Counting Unique Alpahnumeric's in a list 1

Top