![]() |
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