View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rhys rhys is offline
external usenet poster
 
Posts: 1
Default 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.