Thread: Duplicate rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Duplicate rows

I have a list that contains approx 4000 rows of info - school code,
school name, address and email. Some school codes are duplicated as a
result of a workbook merge. I need to search through the information,
find the duplicated rows and delete the row that DOES NOT contain an
email address. How do I do this within Excel, or is this easier in
Access?