| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of row where are data | Excel Discussion (Misc queries) | |||
| How do I take data entries and assign them to specific cells that. | Excel Discussion (Misc queries) | |||
| How do I avoid saving multiple data files for versioning purposes. | Excel Discussion (Misc queries) | |||
| Count cells with data | New Users to Excel | |||
| Count data entries and date problem | Excel Worksheet Functions | |||
Linear Mode
