View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vel Vel is offline
external usenet poster
 
Posts: 9
Default Help with merging data

I have 2 lists of e-mail addresses in escell. Some addresses in list one (in
column 1) are repeated in the 2nd list (in column 2). Is there a way I can
combine the two lists and by doing so automatically to delete the duplicate
records and just leaving one of each duplicate record available in the final
combined list?