Results 1 to 5 of 5

Thread: Compare two Excel files

  1. #1
    Join Date
    Nov 2008
    Posts
    1,259

    Compare two Excel files

    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?

  2. #2
    Join Date
    May 2008
    Posts
    271

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

  3. #3
    Join Date
    May 2008
    Posts
    685

    Re: Compare two Excel files

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

  4. #4
    Join Date
    May 2008
    Posts
    271

    Re: Compare two Excel files

    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.

  5. #5
    Join Date
    Nov 2008
    Posts
    1,259

    Re: Compare two Excel files

    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.

Similar Threads

  1. How to compare text string of two different columns in Excel
    By Chini mao in forum Windows Software
    Replies: 3
    Last Post: 06-01-2012, 03:50 PM
  2. Replies: 4
    Last Post: 05-01-2012, 04:52 PM
  3. Formula to compare two dates in Excel
    By zaid in forum Windows Software
    Replies: 3
    Last Post: 15-10-2009, 05:30 PM
  4. Compare two Excel Worksheets on Mac
    By Claudius in forum Windows Software
    Replies: 2
    Last Post: 10-06-2009, 10:46 PM
  5. Compare lines of 2 txt files in C#
    By !const in forum Software Development
    Replies: 4
    Last Post: 11-04-2009, 05:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •