Compare two Excel files

[Bull50]

Sponsored Links

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?

[XSI]

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).

[fellah]

You can use software (often paying) otherwise save in csv and compare the text mode (with Total Commander, ultra edit, notepad++, ...)

[XSI]

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.

[Bull50]

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.