I have an email list of over 5000 names. Some emails appear more than once on the list. How do I tell Excel to search the spreadsheet, eliminate the duplicate entries and shift the cells up when the entry is deleted? TY so much!! The Excel spreadsheet just has one column - emails.