ExcelBanter - count data but avoid double entries

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

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

- - count data but avoid double entries (https://www.excelbanter.com/excel-worksheet-functions/7894-count-data-but-avoid-double-entries.html)

Manos

count data but avoid double entries

Dear all
i have a quite big spreadsheet with 50.000 entries in rows.
i want in column A to count the entries but not to count the double entries.
There are some data that exist 2 till 10 times.
There is any possibility to count the rows in column A but to avoid the
double entries?

Thanks in advance
Manos

Biff

Hi!

Try this:

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

Biff

-----Original Message-----
Dear all
i have a quite big spreadsheet with 50.000 entries in
rows.
i want in column A to count the entries but not to count
the double entries.
There are some data that exist 2 till 10 times.
There is any possibility to count the rows in column A
but to avoid the
double entries?

Thanks in advance
Manos
.

All times are GMT +1. The time now is 10:22 AM.