compare two Excel files for differences

I

ILoveMyCorgi

I have two Excel files with data. One file contains data in Columns A
through BK, one header row with data [row1] and data in row 2 through 1016.
The other file contains data, same as the first file but only goes from row
row 2 through 903. Is there something I can run that will compare both files
and give me an output of the differences between both files? For instance,
if Column C row 8 has "false" in file 1 and file 2 column c row 8 is blank
the output would display the two differences. I am working with tables in a
database and we are migrating to SQL and the tables need to be exact... a big
task considering there are numerous tables with more numerous fields. Any
help/suggestions would be greatly appreciated!!! Thank you. Susan
 
J

Jim Cone

My commercial Excel add-in "XL Companion" will do that.
Email and ask for the free trial version.
Remove xxx from my email address... james.coneXXX at comcast.netXXX
Please provide your real name and geographic location.
--
Jim Cone
Portland, Oregon USA



"ILoveMyCorgi"
<[email protected]>
wrote in message
I have two Excel files with data. One file contains data in Columns A
through BK, one header row with data [row1] and data in row 2 through 1016.
The other file contains data, same as the first file but only goes from row
row 2 through 903. Is there something I can run that will compare both files
and give me an output of the differences between both files? For instance,
if Column C row 8 has "false" in file 1 and file 2 column c row 8 is blank
the output would display the two differences. I am working with tables in a
database and we are migrating to SQL and the tables need to be exact...
a big task considering there are numerous tables with more numerous fields.
Any help/suggestions would be greatly appreciated!!! Thank you. Susan
 
I

ILoveMyCorgi

Is this a Microsoft product? Do you have a link or email address of where I
can request Excel Companion? Susan

ILoveMyCorgi said:
Thank you so much. I will email today. Susan

Jim Cone said:
My commercial Excel add-in "XL Companion" will do that.
Email and ask for the free trial version.
Remove xxx from my email address... james.coneXXX at comcast.netXXX
Please provide your real name and geographic location.
--
Jim Cone
Portland, Oregon USA



"ILoveMyCorgi"
<[email protected]>
wrote in message
I have two Excel files with data. One file contains data in Columns A
through BK, one header row with data [row1] and data in row 2 through 1016.
The other file contains data, same as the first file but only goes from row
row 2 through 903. Is there something I can run that will compare both files
and give me an output of the differences between both files? For instance,
if Column C row 8 has "false" in file 1 and file 2 column c row 8 is blank
the output would display the two differences. I am working with tables in a
database and we are migrating to SQL and the tables need to be exact...
a big task considering there are numerous tables with more numerous fields.
Any help/suggestions would be greatly appreciated!!! Thank you. Susan
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How To Compare Two Csv Files Mainly Two Columns Containing Time 0
Locating differences in text when comparing two cells 10
Excel 2013 Merge Data 2
compare two files and merge rows base on a matching word within thesetwo rows 1
VBA code To Merge All .csv files into a single excel sheet (data start from row 11th) 2
SORTING DATA IN TWO COLUMNS (salary and name ) - sorting as perdescending order of salary 0
Macro for comparing columns and highlighting matching/differences 13
find and compare data with few workbooks 0

Top