Find the difference between two cells until a break in Column values

[Simondo1964]

I have the following data which i need to process: -

A B C
Tom 39.57
Tom 117.73 Red
Tom 195.89 Red
Tom 195.89 Amber
Tom 352.21 Red
Jerry 508.53
Jerry 586.69 Red
Jerry 264.85 Green
Jerry 343.01 Red


When the values in A1 and A2 are the same I want to find the difference between B1 and B2 and code it Red, Amber, Green dependant on whether it has gone up, down or stayed the same. when the values in column one change I want the formula to return a blank.

I need the formula that will populate col 3.

Thanks,

Simon.

 

[Fluff]

Hi & welcome to MrExcel
In C2 copied down
=IF(A2<>A1,"",IF(B2>B1,"Red",IF(B2=B1,"Amber","Green")))

 

[Simondo1964]

Hi Fluff,

Thanks for this. Couldn't see the wood for the trees!

 

[Fluff]

You're welcome & thanks for the feedback