Delete duplicate rows and retain only one

**canada123** · 02-24-2010, 08:14 PM

Hi,
I want to delete the duplicate rows by comparing numbers and retain only one row from each duplicate rows.

How can i do it? Mock spreadsheet is attached.
Thanks in advance for your expert help.

**Leith Ross** · 02-24-2010, 08:28 PM

Hello cnada123,

Did you want the results on the same sheet or on another sheet? Are looking for a Formula solution or VBA macro?

**canada123** · 02-24-2010, 10:41 PM

Originally Posted by Leith Ross

Hello cnada123,

Did you want the results on the same sheet or on another sheet? Are looking for a Formula solution or VBA macro?

Either same sheet or another sheet will be ok. while VBA macro is preferred.
Thanks for asking.

**Leith Ross** · 02-24-2010, 11:15 PM

Hello Canada123,

This macro has been added to a button on "Sheet1". You will need to change the worksheet name and starting cell to what you will be using. This has been added to the attached workbook.

Please Login or Register  to view this content.

**canada123** · 02-25-2010, 12:44 AM

Originally Posted by Leith Ross

Hello Canada123,

This macro has been added to a button on "Sheet1". You will need to change the worksheet name and starting cell to what you will be using. This has been added to the attached workbook.

Please Login or Register  to view this content.

Hi Leith Ross,
I can't believe.
It worked 100% perfect. Excellent.
Thank you so much. You are genius.

**whatsmyname** · 08-04-2010, 07:40 PM

Hi Leith Ross,

I have been trying to use your code. It is working good for me, but how do I change it from deleting all of the duplicates underneath the the first duplicate row, too deleting all of the duplicates above the last duplicate row.

Also, how do I add code to have it also delete blank rows as well.

Your help is appreciated.

Thank you.