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

Compare Groups of Data to Track Performance
 

Big_Tater wrote:
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


For part the first, use

=MATCH(K1,$B$1:$B$200,0)

For the second part, use conditional formatting. In M1 it would look like

Cell Value Is ... less than ... =J1

and paint it red.