If the range is A1:A100...try this:

B1: =SUMPRODUCT((A1:A100<"")/COUNTIF(A1:A100,A1:A100&""))
That function counts the number of non-blank unique values.

Does that help?

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