ExcelBanter - Count?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count? (https://www.excelbanter.com/excel-worksheet-functions/124153-count.html)

Karl G

Count?

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?

Teethless mama

Count?

=SUMPRODUCT((H28:H36<"")/COUNTIF(H28:H36,H28:H36&""))
Adjust range to suit

"Karl G" wrote:

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?

RagDyeR

Count?

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?

All times are GMT +1. The time now is 06:55 AM.