Comparing multiple columns in two sheets
 

I have two tables with 9 columns (fields) each. I want to cross-check
each table against the other to see what rows appear with all 9 fields
matching in the other table. (i.e. discrepency comparison).

I'd also like to flag which fields are not matching between the two
tables. There are no unique fields out of the 9. (i.e. I can't just
match a number in one table and compare the remaining fields ... any
field may have the same value for several rows).

Anyone have any ideas on how to do a multiple field comparison when
there is not a unique field?

I can write a macro, but thought I'd get some ideas first...

Thanks!

John

Comparing multiple columns in two sheets
 

Make sure the headings in both tables are the same then try an
advanced filter using one table as list range and the other as
criteria range.

If you filter this in place only the records that match will be
showing, you could then fill down an "X" in the adjacent column to
flag the matches.

Do the same for both tables so you get a list of matches, then you can
use autofilter to show the differences between the two tables.


On 30 Mar, 17:26, " wrote:
I have two tables with 9 columns (fields) each. I want to cross-check
each table against the other to see what rows appear with all 9 fields
matching in the other table. (i.e. discrepency comparison).

I'd also like to flag which fields are not matching between the two
tables. There are no unique fields out of the 9. (i.e. I can't just
match a number in one table and compare the remaining fields ... any
field may have the same value for several rows).

Anyone have any ideas on how to do a multiple field comparison when
there is not a unique field?

I can write a macro, but thought I'd get some ideas first...

Thanks!

John