Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 19
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare two tables Mery[_2_] Excel Worksheet Functions 4 May 16th 08 09:28 AM
How do I compare data in two pivot tables [email protected] Excel Discussion (Misc queries) 1 June 12th 06 09:33 PM
Please help how to Compare tables in Excel TotallyConfused Excel Discussion (Misc queries) 3 December 17th 05 03:39 AM
How to compare two tables in Access 2000? Futureer Excel Discussion (Misc queries) 1 June 29th 05 10:54 AM
compare tables Robert Ehrlich Excel Discussion (Misc queries) 2 December 8th 04 02:18 PM


All times are GMT +1. The time now is 01:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"