[Solved] Count years of increasing profits


edit: formula for the better explained requirements in comments (see previous versions in history):

=COLUMN(I2) - MAX(($C2:I2 < $B2:H2) * COLUMN($C2:I2), COLUMN($B2))

10

solved Count years of increasing profits