Comparing Excel files

[dje71183]

Hello all.

I receive once a month a updated pricing for about 25,000 parts. Is there a way to compare the each months and see only the parts that have change?

 

[melone]

1) Concantanate all of the relavant information for each line item (part number, price, etc.) for list 1.

2) Concantanate all of the relavant information for each line item (part number, price, etc.) for list 2.

3) Put list 1 in column 1.

4) Put list 2 in column 2.

5) In column 3, write formula to compare the item in column 1 row x, with all of column 2. Use the Match function (make sure to use the optional parameter at the end)

6) Copy the formula for the entire length of column 1.

7) Repeat 5 & 6 in column 4, but compare column 2 row x, with all of column 1.

If needed, I can post a working version of this spreadsheet.

 

[IRstuff]

If it's a relatively simple list type document, you could output in CSV format and compare in Word, or equivalent.

TTFN

FAQ731-376

 

[GregLocock]

The free programs CSDIFF and winmerge are ideally suited for comparing near identical lists.



Cheers

Greg Locock

SIGlease see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[joerd]

Try

http://www.ozgrid.com/FreeDownloads/Compare.zip

by Stuart Moore.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.