Novice Question Help Please

[LineSheetCom]

I have two spread sheets with email addresses, sheet 1 has 10,000 addresses,
sheet 2 has 25,000 addresses including the 10,000 on sheet 1.

I need to remove the 10,000 names from sheet 2 leaving me with just the 15,000
unique addresses.

Is there a simple answer? or at least is there a complicated answer?

Thanks for any help

 

[Gord Dibben]

One method.......

Copy the 10,000 from sheet1 to sheet2 so you have the duplicates on one sheet.

Then see Debra Dalgleish's instructions on how to extract unique records using
Advanced Filter.

Very simple process.

http://www.contextures.on.ca/xladvfilter01.html#FilterUR

Gord Dibben Excel MVP