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

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.
"Mary" wrote in message
...
Hello,
What is the command for counting number of unique numbers in a column with
potentially duplicative numbers? Thank you so much.

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" wrote:

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

YES - THANKS - I LOVE THIS SITE!!!

"Ron Coderre" wrote:

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" wrote:

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