Compare Groups of Data to Track Performance
 

I am trying to compare 2 groups of data and tell me what rank the item is now
compared to what it was 4 hours ago. Any help is much appreciated as I have
been unsuccessful trying to do on my own.

Morning Report
A1 B1 D1
1 Pepsi2 1
2 Coke1 2
3 BigRed3 3

Mid-Day Report (I paste starting in cell J1 and compare)
J1 K1 M1
1 Coke1 2
2 BigRed3 3
3 Pepsi2 1

My list is an average of 200 products so I want to compare K1 to B1:B200 and
tell me where it used to be ranked. (As an added bonus I would like to have
the new ranking show in RED if it dropped in rankings as the Pepsi2 did
above.)

Any help is VERY much appreciated.
David