Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching and returning values to a master sheet in Excel 2007 Pete Excel Worksheet Functions 0 February 7th 08 03:36 PM
Returning an array of unique values? Blue Max Excel Worksheet Functions 10 January 16th 08 02:51 AM
Max Value Across Worksheets Returning Sheet Name [email protected] Excel Discussion (Misc queries) 2 June 13th 07 01:01 PM
Returning values to unique rows D Zandveld Excel Programming 3 March 14th 07 12:02 PM
Sorting unique values and returning values from a formula MarcusA Excel Programming 2 March 1st 06 05:36 AM


All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"