ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Scrubbing two excel worksheets, returning unique values from one sheet (https://www.excelbanter.com/excel-worksheet-functions/446429-scrubbing-two-excel-worksheets-returning-unique-values-one-sheet.html)

jphogan

Scrubbing two excel worksheets, returning unique values from one sheet
 
Hello,
I'm hoping somebody can help me with this. I have two worksheets with databases of names, addresses, etc. The headers are Email, Name, address, etc.

I want to compare worksheet 1 with worksheet 2 and leave ONLY those records on worksheet 1 that are not found in worksheet two.

I've done a lot of searching through the forums and have only found something similar for single columns, not comparing multiple columns. Any help is appreciated. Thank you!


All times are GMT +1. The time now is 02:45 PM.

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