ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Is it possible to dedupe two excel lists? (https://www.excelbanter.com/excel-worksheet-functions/188095-possible-dedupe-two-excel-lists.html)

LSchroeter, HRW

Is it possible to dedupe two excel lists?
 

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

Is it possible to dedupe two excel lists?
 
Debra Dalgleish shows how to filter unique lists using Advanced Filter
he

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

Hope this helps.

Pete

On May 19, 10:05*pm, LSchroeter, HRW <LSchroeter,
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,




All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com