Debra Dalgleish shows how to filter unique lists using Advanced Filter
here:
http://www.contextures.com/xladvfilter01.html
Hope this helps.
Pete
On May 19, 10:05 pm, LSchroeter, HRW <LSchroeter,
H...@discussions.microsoft.com> wrote:
> 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,