Unique Entries
 

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!
==============================================


"Jason Morin" wrote in message
...
The standard formula (assuming no blanks in A1:A20) is:

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

HTH
Jason
Atlanta, GA

"Kanwaljit Singh Dhunna" wrote:

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)