Sloth,

=SUMPRODUCT((A2:A15<"")/COUNTIF(A2:A15,A2:A15&""))

I agree that the formula is brilliant, but I can't take credit for
inventing it. I'm sure I saw it some time ago in the MS Excel
newsgroups and copied it into my trove of "must have" solutions. I
hope whoever DID invent it sees your compliment and this reply and
takes some satisfaction in knowing that they did the Excel-using
population some good.

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=511929