ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Compare two tables (https://www.excelbanter.com/excel-worksheet-functions/187604-compare-two-tables.html)

Mery[_2_]

Compare two tables
 
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


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com