How to find the differences between 2 Excel files???

J

John Davis

Given 2 excel files with identical fields, how can we find out the
differences between the records??

For example, in file1.xls,
ID Name Amount
1001 N1 A1
1002 N2 A2
1003 N3 A3

in file2.xls,
ID Name Amount
1001 N1 A1
1002 N2 A2
1004 N4 A4

i.e. File1 - File2 will yield record with ID 1004, and File2 - File1 will
yield record with ID 1003?? any operations in Excel can do that??


Please advice. Thanks!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro: How to open not-excel-files by using excelvalue onWorkbooks.Open Filename oa? 0
How to find the differences between 2 Access tables??? 1
how do i loop thru all the worksheets in 2 files one by one 0
formula/a way to find unmatch items in two file 1
how to keep formula don't changed when I copy the file the folder 1
SUMIF and #VALUE! when source is closed? 4
append multiple excel files to access table 0
How can I automatically change the path names of Excel OLE objects in Word Document 3

Top