Comparing lists

[Ralph Burnette]

I'm trying to make a fairly fluid spreadsheet. I have a weekly sales
report that comes out every week that I compare to the prior week to
see detailed sales information on about 2000 skus. I have skus that
come on and off of this report every week.

I want to be able to paste a column of data from the new report each
week next to a column from the prior week and:

a) tell me which skus have been added or subtracted
b) keep existing skus next to eachother automatically

Any help is greatly appreciated. Thanks!

 

[Don Guillett]

I'm trying to make a fairly fluid spreadsheet.  I have a weekly sales
report that comes out every week that I compare to the prior week to
see detailed sales information on about 2000 skus.  I have skus that
come on and off of this report every week.

I want to be able to paste a column of data from the new report each
week next to a column from the prior week and:

a) tell me which skus have been added or subtracted
b) keep existing skus next to eachother automatically

Any help is greatly appreciated.  Thanks!

Send your file with a complete explanation and before/after examples
to dguillett1 @gmail.com