Unique Entries

  • Thread starter Kanwaljit Singh Dhunna
  • Start date
K

Kanwaljit Singh Dhunna

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)
 
R

RagDyer

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
 
Top