How to Count the Unique Value

  • Thread starter Thread starter Alan Tang
  • Start date Start date
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!
 
=SUMPRODUCT((A2:A20<>"")/COUNTIF(A2:A20,A2:A20&""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hosting photos on own server: what are the pros and cons here? 0
Counting unique values in multiple columns 4
Counting Unique Values 6
Complicated Formula Problem 10
Count Unique with condition 7
How to list and count unique records 4
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Display a list of unique values from a column with multiple instances 4

Back
Top