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