Hi All
I am a newbie here so please bare with me. I am trying to recon two sets of data both of which has two columns of info.
I need excel/access to find the exact matches of the two sets of columns and to remove them leaving me with unique info for both the data sets as seen below. Data Below:
[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD]Data Set 1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Data Set 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2500[/TD]
[TD]HAR123[/TD]
[TD][/TD]
[TD]2500[/TD]
[TD]HAR123[/TD]
[/TR]
[TR]
[TD]2000[/TD]
[TD]HAR124[/TD]
[TD][/TD]
[TD]1501[/TD]
[TD]HAR125[/TD]
[/TR]
[TR]
[TD]1500[/TD]
[TD]HAR125[/TD]
[TD][/TD]
[TD]500[/TD]
[TD]HAR127[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]HAR126[/TD]
[TD][/TD]
[TD]2000[/TD]
[TD]HAR124[/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]HAR127[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
After Excel/Access formula or code run (Expected Outcome):
[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD]Data Set 1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Date Set 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1501[/TD]
[TD]HAR125[/TD]
[/TR]
[TR]
[TD]1500[/TD]
[TD]HAR125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]HAR126[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Your assistance will be highly appreciated.
I am a newbie here so please bare with me. I am trying to recon two sets of data both of which has two columns of info.
I need excel/access to find the exact matches of the two sets of columns and to remove them leaving me with unique info for both the data sets as seen below. Data Below:
[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD]Data Set 1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Data Set 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2500[/TD]
[TD]HAR123[/TD]
[TD][/TD]
[TD]2500[/TD]
[TD]HAR123[/TD]
[/TR]
[TR]
[TD]2000[/TD]
[TD]HAR124[/TD]
[TD][/TD]
[TD]1501[/TD]
[TD]HAR125[/TD]
[/TR]
[TR]
[TD]1500[/TD]
[TD]HAR125[/TD]
[TD][/TD]
[TD]500[/TD]
[TD]HAR127[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]HAR126[/TD]
[TD][/TD]
[TD]2000[/TD]
[TD]HAR124[/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]HAR127[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
After Excel/Access formula or code run (Expected Outcome):
[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD]Data Set 1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Date Set 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1501[/TD]
[TD]HAR125[/TD]
[/TR]
[TR]
[TD]1500[/TD]
[TD]HAR125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]HAR126[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Your assistance will be highly appreciated.