How can I count unique strings of data in a field?

ManhattanRebel · Jan 28, 2009

I want to count unique strings of data in a column. Is there a easy way to do
this?

muddan madhu · Jan 28, 2009

try this

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

ManhattanRebel · Jan 28, 2009

Thank you that is exactly what I needed.

muddan madhu said:
try this

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