Try this:

=SUMPRODUCT((A1:A9500<"")/COUNTIF(A1:A9500,A1:A9500&""))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Karl G" wrote in message
...
I have a column of about 9500 numbers, many of them duplicates.I need to
count he numbers in the column but only count the duplicated ones
once.What count function could I use?