Compare Multiple Columns in Two Workbooks for Differences

[mcelligott]

Hello,

I am using Microsoft Excel 2010. I have two workbooks with the same columns. Workbook A has 1169 records and Workbook B has 1127 records. I want to identify the records that are missing in Workbook B from Workbook A. Unfortunately there are no unique keys to only compare one column to one column and there are duplicates in each of them columns. So I need to compare columns B thru J in both workbooks to do a complete and true comparison.

Can anyone please help.

Thanks,

Bob

 

[SkipVought]

Hi,

Use the MATCH() function for all 9 columns.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}