Try this:
=SUMPRODUCT((A1:A30<"")/COUNTIF(A1:A30,A1:A30&""))
Just don't use an entire column as a range (A:A).
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Steembeem" wrote in message
...
I have a large worksheet with a column containing a list of names. Some
names
appear several times. I need to get a count of names.
|