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
--
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?