Creating a list of non-matching values - Excel 2000

[jamey84]

Hi there,

I have run across a dilemma. I have two seperate workbooks. In the first workbook, there is 3 columns, with about 1900 rows of data. The same 3 columns are located in the second workbook as well. What I want to do is to compare the 3 columns from the first workbook to the 3 columns in the second workbook. Here is a sample of what the workbooks look like:

111 Granville - GVL Point Beach - POB
1112 Burlington - BUN Tichigan - TGN
121 Point Beach - POB Forest Junction - FTJ
124 Tayco - TAC Melissa - MEI
13802 Sycamore - SYCA Blount - BLS
13826 West Middleton - WMD Pleasant View - PLV
13856 Cross Country - CCS Fitchburg - FCH
13875 North Madison - NMA West Middleton - WMD
13877 Yahara River - YAR Sycamore - SYCA
13877 North Madison - NMA Yahara River - YAR
13878 Columbia - COL North Madison - NMA
13898 Pleasant View - PLV Cross Country - CCS
151 North Appleton - NAP Point Beach - POB
16342 Empire Mine - EMP National - NAT
16343 National - NAT Tilden - TLD
16344 National - NAT Tilden - TLD
16353 National - NAT Cedar - CDR
1642 Racine - RAC Hayes - HAY
1645 Racine - RAC Somers - SMS


111 Granville - GVL Point Beach - POB
124 Tayco - TAC Melisa - MEI
151 North Appleton - NAP Point Beach - POB
301 Dewey - DEW Valley - VLY
302 Valley - VLY Everett - EVRT
311 Valley - VLY Harbor - HBR
314 Valley - VLY Haymarket Sq - HYS
321 Valley - VLY Park Hill - PKH
324 Valley - VLY Everett - EVRT
446 Presque Isle - PQI National - NAT
457 Empire - EMP Presque Isle - PQI
468 Presque Isle - PQI Perch Lake - PLK
481 Presque Isle - PQI Dead River - DRV
611 Pleasant Prairie - PLP Bain - BAN
612 Pleasant Prairie - PLP Arcadian - ADN
631 Racine - RAC Pleasant Prairie - PLP
641 Pleasant Prairie - PLP Bain - BAN
742 Saukville - SAU Port Washington - POW
751 Range Line Switching - RLN Port Washington - POW
752 Saukville - SAU Port Washington - POW
761 Range Line Switching - RLN Port Washington - POW

I then want to create a new list(on a new worksheet perhaps?) of all the rows that DO NOT match completely.

I have tried many different ways of doing this, with no result. If anyone can lend me a hand with this, it would be greatly appreciated. The columns must stay in the order that they are now, due to company standards. I know that everyone who patrols this site is very knowledgable, and has given me help in the past. I look foward to any help or advice that you can give me. Thanks!

Jamey

If this is not possible, a list of the matching values would be workable.

 

[Joe4]

If you have Micorsoft Access, you can do this pretty easily with an Unmatched Query Wizard. You don't even need to import the data into Access, you can link it in.

 

[LTunnicliffe]

I agree with jmiskey but I took an excel approach.

Book1
	A	B	C	D	E	F	G
1	1	1	1	1
2	4	0	4	0	124Tayco	TACMelisa	MEI
3	13	13	1	169
4	0	0	0	0	301Dewey	DEWValley	VLY
5	0	0	0	0	302Valley	VLYEverett	EVRT
6	0	0	0	0	311Valley	VLYHarbor	HBR
7	0	0	0	0	314Valley	VLYHaymarketSq	HYS
8	0	0	0	0	321Valley	VLYParkHill	PKH
9	0	0	0	0	324Valley	VLYEverett	EVRT
10	0	0	14	0	446PresqueIsle	PQINational	NAT
11	0	0	0	0	457Empire	EMPPresqueIsle	PQI
12	0	0	0	0	468PresqueIsle	PQIPerchLake	PLK
Sheet3

NOTE that Sheet1 and Sheet2 would be your workbooks.

Hope this works!

 

[jamey84]

jmiskey,

Thanks for the help! The Unmatched Query Wizard worked excellent!

Jamey

 

[Joe4]

Glad to hear it!

I prefer Excel over Access whenever possible myself, but there are just some things that Access does better than Excel.