delete duplicate rows
 

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.

delete duplicate rows
 

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.
-----Original Message-----
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.
.

delete duplicate rows
 

Hi,

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

Look for DeleteDuplicateRows macro.

Regards,
Shah Shailesh

-----Original Message-----
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.
.