How to Count the Unique Value

's Computer Specifications

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!

's Computer Specifications

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alan Tang" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Attempting to sort unique/only count first record in each unique g	=?Utf-8?B?TUpX?=	Microsoft Excel Misc	3	10th Aug 2007 02:56 PM
Count unique records for unique criteria	Vette66	Microsoft Excel Worksheet Functions	0	10th Oct 2004 06:39 PM
Count unique records for unique criteria	Vette66	Microsoft Excel Worksheet Functions	1	9th Oct 2004 06:44 PM
Count unique records for unique criteria	Vette66	Microsoft Excel Worksheet Functions	1	8th Oct 2004 09:54 PM
Count unique records for unique criteria	Vette66	Microsoft Excel Worksheet Functions	1	8th Oct 2004 08:08 PM