Count unique text
 

Is there a function, or good way,to count unique text in a list? For
example, I would like an answer of 3 from the text in the list below:

Dog
Cat
Dog
Bird

Thanks!

Count unique text
 

Assume your range is A1:A10:

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

--
Regards,
Dave


"shzdug" wrote:

Is there a function, or good way,to count unique text in a list? For
example, I would like an answer of 3 from the text in the list below:

Dog
Cat
Dog
Bird

Thanks!

Count unique text
 

These will work too:
=SUM(IF(FREQUENCY(MATCH(A2:A11,A2:A11,0),MATCH(A2: A11,A2:A11,0))0,1))

=SUMPRODUCT((A2:A11<"")/(COUNTIF(A2:A11,A2:A11&"")))

=SUMPRODUCT((A2:A11<"")/(COUNTIF(A2:A11,A2:A11)+(A2:A11="")))

=SUMPRODUCT(--(A2:A11<""),1/COUNTIF(A2:A11,A2:A11&""))

=SUM(IF(FREQUENCY(IF(LEN(A2:A11)0,MATCH(A2:A11,A2 :A11,0),""),IF(LEN(A2:A11)0,MATCH(A2:A11,A2:A11,0 ),""))0,1))
(Note: This is a CSE Function)

Adjust all ranges to suit...

--
RyGuy


"David Billigmeier" wrote:

Assume your range is A1:A10:

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

--
Regards,
Dave


"shzdug" wrote:

Is there a function, or good way,to count unique text in a list? For
example, I would like an answer of 3 from the text in the list below:

Dog
Cat
Dog
Bird

Thanks!