Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare two tables | Excel Worksheet Functions | |||
How do I compare data in two pivot tables | Excel Discussion (Misc queries) | |||
Please help how to Compare tables in Excel | Excel Discussion (Misc queries) | |||
How to compare two tables in Access 2000? | Excel Discussion (Misc queries) | |||
compare tables | Excel Discussion (Misc queries) |