Delete Row where duplicate value in A column but leave first number

Hi, does this work? (assuming data is in columns a-j and rows 1-22) can be edited to increase range

Please Login or Register  to view this content.

Hi Patish,

1) If you wanted to check for duplicates in another column (such as E) you would only change Columns =1 Columns:=5. The rest of the code can all stay the same


2) yes it doesn't matter if the value in the cell is a Number or a text, if it finds a duplicate value in the column it will delete the whole row

3) yes if you need to change it to that big a range should work but I if you are not using the entire worksheet try to select only what you need as I think it could make it slow

good luck!

Hi Patish,

1) Yes that's right, if you wanted to check for duplicates in another column (such as E) you would only change Columns =1 Columns:=5. The rest of the code can all stay the same


2) yes it doesn't matter if the value in the cell is a Number or a text, if it finds a duplicate value in the column it will delete the entire row

3) yes if you need to change it to that big a range it should work I if you are not using the entire worksheet try to select only what you need as I think it could make it slow

good luck!