I have Excel files with a lot of line (2000) and column (20). I would like to compare. But even with 2 screens is a bit tedious. Is there a program that would compare two Excel files?
Printable View
I have Excel files with a lot of line (2000) and column (20). I would like to compare. But even with 2 screens is a bit tedious. Is there a program that would compare two Excel files?
Should copy the columns of two files in a single Excel spreadsheet (40 columns, therefore), and add a column to the end that makes a comparison between cells "sisters" (the same cells from two different files).
You can use software (often paying) otherwise save in csv and compare the text mode (with Total Commander, ultra edit, notepad++, ...)
In fact, depending on whether the two files are identical to the data, with certain exceptions. If yes, it's very simple to do with a little formula that compares the cells between them.
Unfortunately, there may be a lot of difference. Basically this is a summary files store stock at 2 different times. So the number of lines is not necessarily the same which constitute the first problem. Then there are different quantities.
I downloaded "Spreadsheet Compare" but if there are too many differences that plant.