Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Compare two Excel files

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-04-2009
Member
 
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?

Reply With Quote
  #2  
Old 06-04-2009
XSI XSI is offline
Member
 
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).
Reply With Quote
  #3  
Old 06-04-2009
Member
 
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++, ...)
Reply With Quote
  #4  
Old 06-04-2009
XSI XSI is offline
Member
 
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.
Reply With Quote
  #5  
Old 06-04-2009
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Compare two Excel files"
Thread Thread Starter Forum Replies Last Post
How to compare text string of two different columns in Excel Chini mao Windows Software 3 06-01-2012 03:50 PM
How to compare two colums in Excel and find the differennce also Haimi-32 MS Office Support 4 05-01-2012 04:52 PM
Formula to compare two dates in Excel zaid Windows Software 3 15-10-2009 05:30 PM
Compare two Excel Worksheets on Mac Claudius Windows Software 2 10-06-2009 10:46 PM
Compare lines of 2 txt files in C# !const Software Development 4 11-04-2009 05:36 PM


All times are GMT +5.5. The time now is 09:13 PM.