counting number of unique entries in a list

  • Thread starter Thread starter mtw
  • Start date Start date
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
 
=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...
 
Back
Top