Help with merging data

  • Thread starter Thread starter vel
  • Start date Start date
V

vel

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?
 
One quick n easy way

Do a manual copy n paste of the 2nd list below the 1st

Then run a uniques filter on the combined listing in the 1st col, viz.:

Select the entire 1st col
Click Data > Filter > Advanced Filter
(Answer "Yes" to the prompt)
Check "Copy to another location"
Copy to: C1 (say)
Check "Unique records only"
Click OK, and the uniques listing will appear in col C
 
Back
Top