Unique Entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A1:A20 contains 4 unique names. Formula applied in B1 should give the result
that how many No. of Unique names are there in range A1:A20 (i.e., the result
should be 4)
 
And if there should happen to be the possibility that there might be blanks,
you could try this:

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


The standard formula (assuming no blanks in A1:A20) is:

=SUMPRODUCT(1/COUNTIF(A1:A20,A1:A20))

HTH
Jason
Atlanta, GA
 
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

Retrieve unique items with 2 criteria (USING SUMPRODUCT) 5
Sum number range ignoring numbers formatted as text 0
Counting independent items in a list 3
Sumif criteria appears twice 9
retrieve unique items with 2 criteria 10
If & sumproduct formula with text 3
Count unique entries... 5
Loose formula/value (when building graphs) 3

Back
Top