Is it possible to dedupe two excel lists?

[LSchroeter, HRW]

I have two excel spreadsheets with overlapping data and would like to dedupe
them, seperating the unique from the duplicate data.

Does anyone know how I could accomplish this?

TIA,

 

[Pete_UK]

Debra Dalgleish shows how to filter unique lists using Advanced Filter
here:

http://www.contextures.com/xladvfilter01.html

Hope this helps.

Pete