How to Count the Unique Value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan Tang - 26 Dec 2005 10:33 GMT

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!

Reply to this Message

Bob Phillips - 26 Dec 2005 10:39 GMT

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

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Hello:
>
[quoted text clipped - 3 lines]
>
> Thanks a lot!

Reply to this Message