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
1	ID #
2	0188370
3	0283750
4	0299950
5	0316740
6	0416500
7	0538620
8	0543610
9	0554670
10	0556410
11	0572240
12	0724270

<COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"></COLGROUP><TBODY>
</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
1	ID #	YR	TOS	BR	CO	TERM	STATUS	WAGE 1	WAGE 2	WAGE_3	TAX 1	TAX 2	YTD	YTD 2	YTD 3	YTD 4	YTD 5
2	0188370	06	00000	46	S26		A	33225.5	0	22136.5	0	0	0	0	32503.02	22136.5	0
3	0188370	06	00000	46	A01		A	10.2	0	10.2	0	0	0	0	25332	25332	0
4	0188370	06	00000	47	A02		A	2.5	0	2.5	0	0	0	0	23.2	23.2	0
5	0188370	06	00000	48	A01		A	232	0	232	0	0	0	0	2211	2211	0
6	0188370	06	00000	45	A01		A	2123	0	2123	0	0	0	0	22235	22235	0
7	0283750	13	33333	BS	J0X		A	0	0	0	0	0	0	0	0	0	0
8	0283750	13	33333	CS	J0X		A	0	0	0	0	0	0	0	0	0	0
9	0299950	14	33333	72	9HQ		A	37961.53	0	9500	0	256.5	0	0	37189.39	9500	0
10	0316740	14	33333	RW	MVG		A	11538.42	0	9500	0	256.5	0	0	11538.42	9500	0
11	0416500	14	33333	46	SCB		A	0	0	0	0	0	0	0	0	0	0
12	0538620	13	00000	A0	DN3	F	I	0	0	0	0	0	0	0	0	0	0
13	0538620	13	00000	A0	DN3	F	I	0	0	0	0	0	0	0	0	0	0
14	0538620	13	00000	A0	DN3	F	I	0	0	0	0	0	0	0	0	0	0
15	0543610	13	00000	70	WWD		A	5949.32	0	0	0	0	0	0	0	0	0
16	0543610	13	00000	70	WWD		A	5949.32	0	0	0	0	0	0	0	0	0
17	0554670	10	03300	ST	NML6		A	0	0	0	0	0	0	0	0	0	0
18	0556410	11	03333	72	MSV		A	0	0	0	0	0	0	0	0	0	0
19	0572240	10	33333	80	AQD		I	0	0	0	0	0	*	*	*	*	*
20	0724270	14	33333	R2	I34		A	3333.34	0	3333.34	0	90	0	0	3333.34	3333.34	0
21	0724610 *	11	00333	15	3ML		A	388389.81	0	251990.86	0	6803.75	0	0	394163.06	251990.86	0
22	0724610 * *	14	33333	15	E2X		A	17561.48	0	9500	0	256.5	0	0	17561.48	9500	0
23	0724680 *	14	99999	15	9O2	T	A	0	0	0	0	0	*	*	*	*	*
24	APPLFOR042546583	14	03333	46	FH2		A	0	0	0	0	0	*	*	*	*	*
25	APPLFOR043103733	09	30000	46	C4C		A	15759	0	0	0	0	0	0	0	0	0

<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>
</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