Count of unique text

  • Thread starter Thread starter Giri
  • Start date Start date
G

Giri

Hi,

Suppose A1 to A5 has text info. How do i get a count
of number of unique text of the above ?

Eg: A1=a,A2=a,A3=b,A4=c,A4=b. I need the count to show 3
since there exists a,b,c as unique.

Thanks for your help.

Regards,
Giri
 
Hi,

Try to use this array formula assuming you have no blanks
in your data.


=SUM(1/COUNTIF(A1:A5,A1:A5))

To make array formula you have to press CTRL+SHIFT+ENTER.

Regards,
Shailesh Shah
 
Giri,

Assuming no blanks in the range, found this array formula by David Hager at
Chip Pearson's site -

=SUM(1/COUNTIF(A1:A5,A1:A5))

Use CTRL+Shift+Enter rather than plain Enter.

Rgds,
Andy
 
Back
Top