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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"vel" wrote in message
...
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?