Comparing Excel files
Comparing Excel files
(OP)
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?
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?





RE: Comparing Excel files
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.
RE: Comparing Excel files
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Comparing Excel files
Cheers
Greg Locock
SIG:Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Comparing Excel files
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.