If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatically deleting duplicate rows??
Hello,
I have searched through the help but couldnt find out how you can delete duplicate rows in an Excel spreadsheet without having to manually go through and compare them. Is it possible to automate it?? Ta folks, Ritchie ) |
#2
|
|||
|
|||
Automatically deleting duplicate rows??
Hi, Ritchie. See http://www.cpearson.com/excel/deleting.htm.
"Ritchie Jones" wrote: Hello, I have searched through the help but couldnt find out how you can delete duplicate rows in an Excel spreadsheet without having to manually go through and compare them. Is it possible to automate it?? Ta folks, Ritchie ) |
#3
|
|||
|
|||
Automatically deleting duplicate rows??
If you don't want to write a macro, I have an alternative idea:
First, sort the list by the column that you are trying to detect duplication, Say Column M. Second, insert a column in the table or find a blank column somewhere, say column N write this formulae: Cell N2 write : "=if(M2=M1, 1, 0)", copy this formula to the end of the list. Third, clear the fomulae by copypastespecial values. Finally, use either sort column N and delete the 1s or use a filter to flush out the 1s and delete them. I have been using this method for years, it only takes me a few seconds to do it. "Ritchie Jones" wrote: Hello, I have searched through the help but couldnt find out how you can delete duplicate rows in an Excel spreadsheet without having to manually go through and compare them. Is it possible to automate it?? Ta folks, Ritchie ) |
#4
|
|||
|
|||
Automatically deleting duplicate rows??
Ritchie
Can be done through Advanced Filtering. See Debra Dalgleish's site for instructions with pictures. http://www.contextures.on.ca/xladvfi....html#FilterUR Gord Dibben Excel MVP On Wed, 30 Jun 2004 03:56:31 -0700, "Ritchie Jones" wrote: Hello, I have searched through the help but couldnt find out how you can delete duplicate rows in an Excel spreadsheet without having to manually go through and compare them. Is it possible to automate it?? Ta folks, Ritchie ) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Duplicate Rows | Dtruelove | Worksheet Functions | 2 | May 26th, 2004 03:15 PM |
Deleting Empty Rows | Dolphinv4 | Worksheet Functions | 0 | March 15th, 2004 03:21 AM |
Duplicate searching through multiple columns, rows | Eliezer | Worksheet Functions | 1 | January 30th, 2004 06:28 PM |
deleting duplicate rows | margaret | Worksheet Functions | 1 | September 15th, 2003 09:13 PM |