Forum Discussion
Compare several excel workbooks
I need to compare approximately 8 excel workbooks for differences.
I have come across the following:
https://support.office.com/en-us/article/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842?ocmsassetID=HA010047494&CorrelationId=d6d7be5e-b8c5-4016-b593-8ec175823669&ui=en-US&rs=en-US&ad=US
However, it is beyond my comprehension, and concerned that I will mess it up.
Is there anyone able to assist for a small fee?
11 Replies
- What -preciesly- needs to be compared between these 8 files? Data, Formulas, other things?
Hi Jan,
I wish to compare a row with two columns, one containing a name of a person, the second containing their e-mail address.
Indeed, merely comparing e-mail addresses would be enough.
- Is this a one-off thing? If yes I would simply copy/paste the data into one single sheet with an additional column for the filename. You could also use Data, New Query, From File, From Folder and go from there.
Hi David,
The link you mentioned isn't related to what you asking for!
You may check out this https://www.ablebits.com/office-addins-blog/2016/02/25/compare-two-excel-files-sheets/ instead.
Hope that helps
Thank you for that Haytham. It was interesting to read it but it only offers advice on comparing two excel worksheets. I have multiple sheets I wish to compare.
