Oct 18 2023 07:52 AM
Oct 18 2023 07:52 AM
After a crash, I save an excel file with a new name. Then later on I used the old file with the original name and then the file saved with the new name, when I should have used only the newly named file. So there are entries missing or wrong in the newly named file. Is there a way to compare them other than side-by-side going line by line? I have over 2000 lines.
Oct 18 2023 08:15 AMSolution
Comparing two Excel files can be a bit tricky, especially when dealing with large datasets.
Comparing 2 different Excel files in this link you will find a solution proposal.
Here's a more detailed solution using a third-party tool called "Beyond Compare." Beyond Compare is a powerful file comparison tool that can be used to compare Excel files effectively. Please follow these steps:
Please note that Beyond Compare is not a free tool, but it offers a 30-day trial, which should be sufficient for your needs. If you find it valuable, you can purchase a license.
Using Beyond Compare or similar comparison tools can significantly speed up the process of comparing and merging Excel files, especially when dealing with a large number of records.
If you prefer not to use third-party tools, you can perform a basic comparison of two Excel files using built-in features like conditional formatting. Here's a step-by-step guide:
This formula will highlight cells in the target sheet where the content in the same cell in the other file is different.
This method is basic and will help you visually identify the differences between two Excel files. However, it won't provide a side-by-side comparison like third-party tools do, and you'll need to resolve differences manually. For very large datasets, a third-party tool might be more efficient.
The text was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Oct 18 2023 01:31 PM
@NikolinoDE THANK YOU!!!!!! You saved me more hours than you can imagine. I used the third party Beyond Compare program and it worked very well. I had a little trouble because both excel files also have multiple sheets and it took a while to get it to compare the same sheet in each file. Once I did, it was great.