ExcelBanter - Count unique values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count unique values (https://www.excelbanter.com/excel-worksheet-functions/66505-count-unique-values.html)

Mary

Count unique values

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

Alan

Count unique values

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.

Ron Coderre

Count unique values

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.

Mary

Count unique values

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.

All times are GMT +1. The time now is 02:18 AM.