Thank you for your reply.

Sorry about that. The formulas are in the following cells.
B153, C153, E153 and F153.

What happens is, if he road conditions are the same but the weather changes the formula does not report the weather change or road condition. To see what I mean change the values in the range I138 to I145 to ICY. You will see the report picks that up. The issue is that there are many occasions when the road conditions will remain the same but the weather conditions will change.