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