I need to find the count of a list of numbers listed in a
column(specific). But where the number exists more than once I need it
to be counted only once. In the example below this formula should
return 4 as the answer. Thanks in advance.

Example:

Column B
23789
24567
23789
14578
09075
23789


--
Michael Wise
------------------------------------------------------------------------
Michael Wise's Profile: http://www.excelforum.com/member.php...fo&userid=6998
View this thread: http://www.excelforum.com/showthread...hreadid=541534