Get the Count of Unique Values in a Column [Archive]

View Full Version : Get the Count of Unique Values in a Column

Jeevie

12-22-2011, 07:41 AM

Hi All

I am trying to create a formula to get the count of unique values in a column. Can someone help or provide directions ?

Appreciate any help.

mikerickson

12-22-2011, 08:03 AM

How about =SUMPRODUCT(1/COUNTIF(A1:A10, A1:A10&"")), which counts blank cells as a value

or =SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10&""))-SIGN(COUNTIF(A1:A10,"")), which ignores blank cells.