trying to compare two tables

Drew

Board Regular
Joined
Feb 18, 2002
Messages
185
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hello,
Not sure if this is the way to go…
I’m trying to compare tbl 1 to tbl 2. From the compare, I would like to produce a list of records from tbl 1 that aren’t contained in tbl 2. Similar to a fuzzy search??
Ex.
Record 1 in tbl 1 “A0” exists (contained) in all 14 records from tbl 2, so this would be excluded from the results list.
Record 2 in tbl 2 “A0%%%0” exists (contained) in the first 2 records from tbl 2, so this would be excluded from the results list. Etc…
Record 8 in tbl 2 “A0%%%1D”, doesn’t exist in tbl 2, so this would be part of the list. Etc..

Table 1 Table 2
A0 A0%%%0A
A0%%%0 A0%%%0B
A0%%%0A A0%%%1A
A0%%%0B A0%%%1B
A0%%%1 A0%%%2A
A0%%%1A A0%%%2B
A0%%%1B A0%%%3A
A0%%%1D A0%%%3B1A
A0%%%2 A0%%%3B1B
A0%%%2A A0%%%3B1C1
A0%%%2B A0%%%3B1C2
A0%%%2C A0%%%3B1D
A0%%%3 A0%%%3B1E
A0%%%3A A0%%%3B1F
A0%%%3B

So, results from the example above would be:
Tbl
A0%%%1D
A0%%%2C

Thanks for the help.
Drew
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

mdmilner

Well-known Member
Joined
Apr 30, 2003
Messages
1,352
If and only If you're looking for exact matches you can take a shot at the 'Find Duplicates' QBE Wizard interface built into Access. Viewing the SQL code that it generates would be a great demo on how to futher modify it to do what you might need.

If you're familiar with defining fields inside a query, you could always use that to extract portions of strings to compare in the same fashion.

I would recommend that if both topics are new to you, that you try them out separately and then try to combine them once you get them down.

Mike
 

Forum statistics

Threads
1,136,425
Messages
5,675,770
Members
419,585
Latest member
popsin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top