Sorry in advance, I'm an excel newbie and I'm asking on behalf of the boss since I've had
good luck with this forum in the past. Hope I can phrase the question properly.
We have a list of products and their sales figures from 2014.
We have a similar list of products from 2015, but a few items were added and removed.
How can I compare sales figures between the 2 years,
but only for products that exist in both years...
ignoring products that were added/dropped?
The results of this comparison could be output to a new column...
Or maybe just highlighted in the 2015 column, e.g. red = sales decreased, green = sales increased.
Whatever's easiest.
Note that the same product names appear under multiple distributors,
so e.g. Ajax Turner shows Alfredo Roca in one year, but not the other.
But Aleksey's has Alfredo Roca also, and it appears both years.
The screenshot may help make it clearer I hope.
Thanks very much in advance!
excel_question.jpg
Bookmarks