| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I identify dulicate rows in a spreadsheet?
I have a spreadsheet with over a thousand rows. That sheet contains five
columns. I am doing an average on column 5, but have some duplicates. I want to identify those duplicates so that I can eliminate them. If columns 1, 2 and 3 are the same for any of the rows, the row(s) is a duplicate. Is there an easy way to identify these duplicates quickly, using a function or pivot table? Thanks for any help!! Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
| Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
| How do I delete blank rows at the bottom of a spreadsheet to get . | Excel Discussion (Misc queries) | |||
| copy qualifying rows to another spreadsheet | Excel Worksheet Functions | |||
| Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions | |||
Threaded Mode
