Excel Jeanie HTML 4 SHEET2 TOAD QUERY .">
Most valuable professional
  • 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:

  • Excel
  • Microsoft Excel