delete duplicate rows

  • Thread starter Thread starter rhys
  • Start date Start date
R

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.
 
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.
 
Back
Top