- Hot Topics
Excel Comparing two worksheets to find the match including the duplicates
Hi, I have two worksheets that i'd like to compare the IDs to find the match including the duplicates. IDs in Sheet1 will be compared to a queried data with IDs in Sheet2. If it's possible if there's a code that can make this compare, create a tab labeled Matched including the duplicates, another tab labeled No match IDs from Sheet1 that didn't match to Sheet2, and lastly a tab that matched the IDs but has no duplicate IDs. Thank you! Here's an example of the worksheets. SHEET1 IDS * 1 2 3 4 5 6 7 8 9 10 11 12 Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4 SHEET2 TOAD QUERY
This question generated 23 answers. To proceed to the answers, click here.
This thread is current as of April 18, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel