Count?

K

Karl G

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?
 
R

RagDyeR

Try this:

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

--

HTH,

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

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?
 
Top