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-aa8c2a8...
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.
Thank you Jan. Yes it is a 'one-off' thing. Basically I am trying to compare data (names) from multiple sheets.
I have done what you recommend, which is to copy and paste the names into a single sheet. I now have 6 columns of names and I now need identify which repeat from in every columns (although they are not necessarily also on the same row in each column) or to identify those names that do not repeat. Not sure that 'Conditional Formatting' and 'Duplicate Values' does it correctly.
- The conditional formatting should work just fine (highlight duplicates)..