Oct 15 2018 01:54 AM
I need to compare approximately 8 excel workbooks for differences.
I have come across the following:
However, it is beyond my comprehension, and concerned that I will mess it up.
Is there anyone able to assist for a small fee?
Oct 15 2018 07:51 AM
Hi David,
The link you mentioned isn't related to what you asking for!
You may check out this link instead.
Hope that helps
Oct 15 2018 07:57 AM
Oct 17 2018 10:34 PM
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.
Oct 17 2018 10:37 PM
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.
Oct 18 2018 12:50 AM
Oct 21 2018 11:34 PM
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.
Oct 22 2018 01:25 AM
Oct 22 2018 02:15 AM
Thank you Jan. One final question, promise. The list is a very long one - around 15,000 names, so it is having a problem coping with it. I presume I just need to be patient.
However, what I want to make sure of is that the duplicates are only identified if the name appears in all of the columns. Can you confirm that this is what the Conditional Formatting analysis provides. If the name was in 5 out of the 6 columns, I would not wish it to be highlighted.
Oct 22 2018 02:51 AM