delete duplicate rows

[rhys]

i have a spreadsheet with duplicate email entries.
anyone know of a macro that can go down through the rows,
check to see if an email address is in any previous rows
and if so delete all remaining rows that contain that
duplicate email address?

cheers,

rhys.

 

[Dave Ramage]

Rhys,

One method is to use the Advanced Filter
(Data/Filter/Advanced Filter) with the Unique Records Only
option and no criteria.

To find how to use this in VBA use the macro recorder.

Cheers,
Dave.

 

[Shah Shailesh]

Hi,

You can also see this link.
http://www.cpearson.com/excel/deleting.htm

Look for DeleteDuplicateRows macro.

Regards,
Shah Shailesh