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!
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!
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks