Comparing two worksheets to find the match including the duplicates

[nike]

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

*	A

<COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"></COLGROUP><TBODY>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="bgcolor: #c0c0c0"]ID #[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: left"]0188370[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: left"]0283750[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: left"]0299950[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: left"]0316740[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: left"]0416500[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: left"]0538620[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: left"]0543610[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: left"]0554670[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: left"]0556410[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="align: left"]0572240[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]
[TD="align: left"]0724270[/TD]

</TBODY>

Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

SHEET2

TOAD QUERY

*

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

S26

A

A01

A

A02

A

A01

A

A01

A

BS

J0X

A

CS

J0X

A

9HQ

A

RW

MVG

A

SCB

A

A0

DN3

F

I

A0

DN3

F

I

A0

DN3

F

I

WWD

A

WWD

A

ST

NML6

A

MSV

A

AQD

I

*

*

*

*

*

R2

I34

A

3ML

A

E2X

A

9O2

T

A

*

*

*

*

*

APPLFOR042546583

FH2

A

*

*

*

*

*

APPLFOR043103733

C4C

A

<COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 62px"><COL style="WIDTH: 23px"><COL style="WIDTH: 47px"><COL style="WIDTH: 28px"><COL style="WIDTH: 51px"><COL style="WIDTH: 41px"><COL style="WIDTH: 64px"><COL style="WIDTH: 81px"><COL style="WIDTH: 67px"><COL style="WIDTH: 81px"><COL style="WIDTH: 41px"><COL style="WIDTH: 74px"><COL style="WIDTH: 35px"><COL style="WIDTH: 46px"><COL style="WIDTH: 79px"><COL style="WIDTH: 79px"><COL style="WIDTH: 41px"></COLGROUP><TBODY>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="bgcolor: #c0c0c0"]ID #[/TD]
[TD="bgcolor: #c0c0c0"]YR[/TD]
[TD="bgcolor: #c0c0c0"]TOS[/TD]
[TD="bgcolor: #c0c0c0"]BR[/TD]
[TD="bgcolor: #c0c0c0"]CO[/TD]
[TD="bgcolor: #c0c0c0"]TERM[/TD]
[TD="bgcolor: #c0c0c0"]STATUS[/TD]
[TD="bgcolor: #c0c0c0"]WAGE 1[/TD]
[TD="bgcolor: #c0c0c0"]WAGE 2[/TD]
[TD="bgcolor: #c0c0c0"]WAGE_3[/TD]
[TD="bgcolor: #c0c0c0"]TAX 1[/TD]
[TD="bgcolor: #c0c0c0"]TAX 2[/TD]
[TD="bgcolor: #c0c0c0"]YTD [/TD]
[TD="bgcolor: #c0c0c0"]YTD 2[/TD]
[TD="bgcolor: #c0c0c0"]YTD 3[/TD]
[TD="bgcolor: #c0c0c0"]YTD 4[/TD]
[TD="bgcolor: #c0c0c0"]YTD 5[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: left"]0188370[/TD]
[TD="align: right"]06[/TD]
[TD="align: right"]00000[/TD]
[TD="align: right"]46[/TD]

[TD="align: right"]33225.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]22136.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]32503.02[/TD]
[TD="align: right"]22136.5[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: left"]0188370[/TD]
[TD="align: right"]06[/TD]
[TD="align: right"]00000[/TD]
[TD="align: right"]46[/TD]

[TD="align: right"]10.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]25332[/TD]
[TD="align: right"]25332[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: left"]0188370[/TD]
[TD="align: right"]06[/TD]
[TD="align: right"]00000[/TD]
[TD="align: right"]47[/TD]

[TD="align: right"]2.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]23.2[/TD]
[TD="align: right"]23.2[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: left"]0188370[/TD]
[TD="align: right"]06[/TD]
[TD="align: right"]00000[/TD]
[TD="align: right"]48[/TD]

[TD="align: right"]232[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]232[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2211[/TD]
[TD="align: right"]2211[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: left"]0188370[/TD]
[TD="align: right"]06[/TD]
[TD="align: right"]00000[/TD]
[TD="align: right"]45[/TD]

[TD="align: right"]2123[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2123[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]22235[/TD]
[TD="align: right"]22235[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: left"]0283750[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]33333[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: left"]0283750[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]33333[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: left"]0299950[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]33333[/TD]
[TD="align: right"]72[/TD]

[TD="align: right"]37961.53[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9500[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]256.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]37189.39[/TD]
[TD="align: right"]9500[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: left"]0316740[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]33333[/TD]

[TD="align: right"]11538.42[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9500[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]256.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]11538.42[/TD]
[TD="align: right"]9500[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="align: left"]0416500[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]33333[/TD]
[TD="align: right"]46[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]
[TD="align: left"]0538620[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]00000[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]
[TD="align: left"]0538620[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]00000[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]14[/TD]
[TD="align: left"]0538620[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]00000[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]15[/TD]
[TD="align: left"]0543610[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]00000[/TD]
[TD="align: right"]70[/TD]

[TD="align: right"]5949.32[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]16[/TD]
[TD="align: left"]0543610[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]00000[/TD]
[TD="align: right"]70[/TD]

[TD="align: right"]5949.32[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]17[/TD]
[TD="align: left"]0554670[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]03300[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]18[/TD]
[TD="align: left"]0556410[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]03333[/TD]
[TD="align: right"]72[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]19[/TD]
[TD="align: left"]0572240[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]33333[/TD]
[TD="align: right"]80[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]20[/TD]
[TD="align: left"]0724270[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]33333[/TD]

[TD="align: right"]3333.34[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3333.34[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3333.34[/TD]
[TD="align: right"]3333.34[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]21[/TD]
[TD="align: right"]0724610 * [/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]00333[/TD]
[TD="align: right"]15[/TD]

[TD="align: right"]388389.81[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]251990.86[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6803.75[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]394163.06[/TD]
[TD="align: right"]251990.86[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]22[/TD]
[TD="align: right"]0724610 * * [/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]33333[/TD]
[TD="align: right"]15[/TD]

[TD="align: right"]17561.48[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9500[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]256.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]17561.48[/TD]
[TD="align: right"]9500[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]23[/TD]
[TD="align: right"]0724680 *[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]99999[/TD]
[TD="align: right"]15[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]24[/TD]

[TD="align: right"]14[/TD]
[TD="align: right"]03333[/TD]
[TD="align: right"]46[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]25[/TD]

[TD="align: right"]09[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"]46[/TD]

[TD="align: right"]15759[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

</TBODY>

Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

 

[hiker95]

nike,

I do not understand.

And, I have far exceeded the normal amount of time I allocate for solving problems/requests from web sites like MrExcel.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[nike]

Thanks for your help hiker95!

 

[nike]

bump