Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare two table
Hi, I had transfer a table from the server database to my local computer. Is it possible if use excel to compare those two tables and extract the missing records that were not copy out? regards, ray -- ray5_83 ------------------------------------------------------------------------ ray5_83's Profile: http://www.excelforum.com/member.php...o&userid=29800 View this thread: http://www.excelforum.com/showthread...hreadid=495113 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare two table
Maybe...
Can you pick out a key field/column that is common to both? If you can, you can use some of the techniques that Chip Pearson describes to show the differences: http://www.cpearson.com/excel/duplicat.htm ray5_83 wrote: Hi, I had transfer a table from the server database to my local computer. Is it possible if use excel to compare those two tables and extract the missing records that were not copy out? regards, ray -- ray5_83 ------------------------------------------------------------------------ ray5_83's Profile: http://www.excelforum.com/member.php...o&userid=29800 View this thread: http://www.excelforum.com/showthread...hreadid=495113 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare two table
Thanks Dave, I will take a look on it.... regards, ray -- ray5_83 ------------------------------------------------------------------------ ray5_83's Profile: http://www.excelforum.com/member.php...o&userid=29800 View this thread: http://www.excelforum.com/showthread...hreadid=495113 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Need to compare 2 tables to generate 3rd table | Excel Worksheet Functions | |||
Dynamically compare two slightly different copies of a table | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Is there a way to compare a pivot table refreshed data to old one | Excel Discussion (Misc queries) |