How to write a conditional statement where something occurs twice.

[RavaginRadish]

I am trying to create a function that runs through multiple values and determines where the value in Column A is less than the value in Column B.
This instance has to occur twice within a range of 10 cells (IE: A2:B12), with the range of values exists from A2:B300.

This can happen immediately following one another (A2<B2, A3<B3), or it can happen infrequently (A5<B5, A12<B12).

If this happens twice, my then statement will return the difference between the the cell value of column A in the FIRST instance, and the cell value of column B in the SECOND instance.

IE:
IF
A3<B3
A7<B7

THEN

"A3- B7"

Sorry if this is confusing. English isnt my first language lol

[Ochimus]

Does what you want.

Finds first record where A<B and sets "a" as Col A value
When next row found where A<B, Col C shows "a-Col B value",
Resets "a" as new base value, and deducts that from third instance, then when next found, and so on.

Please Login or Register  to view this content.

Hope this helps

Ochimus