compare 2 excel files

  • Thread starter Thread starter jacob
  • Start date Start date
J

jacob

How do I compare 2 books with the same items one has more
items then the other,it should show me the difrance.
Or even the item is there but the qty or price changed it
should show me the difrence
 
if nothing else changes the filesize should indicate the
file with the most items. Perhaps the last edit date
would do so, as well.
 
jacob said:
How do I compare 2 books with the same items one has more
items then the other,it should show me the difrance.
Or even the item is there but the qty or price changed it
should show me the difrence
Click to expand...

One way is to save both spreadsheets as plain text using
File >> Save as
with "Save as type" equal to CSV.

Open one CSV file in MS-Word, and then use Word's
Tools >> Track changes >> Compare documents
feature to display the difference with the second CSV file.
 
Back
Top