Formula to count uniques in a column

[stephme55]

Hello. is there a formula to find unique values in a columnm? Gracaius

[Chenderson]

Good afternoon Stephme55,

This formula should do the trick!

=SUMPRODUCT(1/COUNTIF(data,data))

(Where data is the range of cells where you would like to count the unique values)


Source :
https://exceljet.net/formula/count-u...e-with-countif

[FlameRetired]

stephme55,

Are wanting to return the actual items

Hello. is there a formula to find unique values in a columnm?

or simply the count (as Chenderson has done)

Formula to count uniques in a column

?