Automatically deleting duplicate rows??

R

Ritchie Jones

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 :eek:)
 
A

Anson

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 copy>pastespecial> 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.
 
Top