Count unique values

Mary · Jan 20, 2006

Hello,
What is the command for counting number of unique numbers in a column with
potentially duplicative numbers? Thank you so much.

Alan · Jan 20, 2006

Try using Advanced Filter to initially ascertain the unique numbers, then us
COUNT, COUNTA etc from there.
First Class advice on Advanced Filter here,
http://www.contextures.com/xladvfilter01.html
Regards,
Alan.

Ron Coderre · Jan 20, 2006

Try this:

For a list in A1:A10

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

Mary · Jan 20, 2006

YES - THANKS - I LOVE THIS SITE!!!

Ron Coderre said:
Try this:

For a list in A1:A10

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

Count unique values

Mary

Alan

Ron Coderre

Mary