Compare two tables

M

Mery

I have 2 tables, column A contains ID, col.B names of employees, col.C
element of pays which it's adjustable. Sometime, same names employees are
retail and first I have to find differences between two table, by criteria
col.C. Now, I need which are differences between table1 & table2, table 1 is
ok. I have 500 employees on my firm and need find differences at once. So,
deferences between e.g. A1:C500 to compare with F1:H500, than differences
copy to another sheet.
TABLE 1 TABLE 2
A B C F G H
001 mery 21 001 mery 20
001 mery 20
003 jim 20 003 jim 20

004 kety 21 004 kety 20

Is it solve?

Regards,
Mery
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top