Basically I have data in columns I and J.
When i drag the following formula (in column K) down, it checks if any two consecutive values in column J are equal to the top two (J3 and J4), and if so, it returns an answer.
IF(AND($J$3=$J5,$J$4=$J6,),($I$3-$I5)+($I$4-$I6),0)
My problem is that I...