How to Count the Unique Value

A

Alan Tang

Hello:

I have all the host name in column A but some of the host name is
duplicate. Would you mind to teach me does any formula that can
calculate the number of unique host?

Thanks a lot!
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top