If I have the following sequence:

[TABLE="width: 1690"]

[TD="class: xl64, width: 65, align: right"]35.9[/TD]

[TD="class: xl64, width: 65, align: right"]35.4[/TD]

[TD="class: xl64, width: 65, align: right"]34.9[/TD]

[TD="class: xl64, width: 65, align: right"]34.1[/TD]

[TD="class: xl64, width: 65, align: right"]33.9[/TD]

[TD="class: xl64, width: 65, align: right"]33.7[/TD]

[TD="class: xl64, width: 65, align: right"]33.5[/TD]

[TD="class: xl64, width: 65, align: right"]33.5[/TD]

[TD="class: xl64, width: 65, align: right"]33.5[/TD]

[TD="class: xl64, width: 65, align: right"]33.5[/TD]

[TD="class: xl64, width: 65, align: right"]33.7[/TD]

[TD="class: xl64, width: 65, align: right"]33.7[/TD]

[TD="class: xl64, width: 65, align: right"]33.7[/TD]

[TD="class: xl64, width: 65, align: right"]34.3[/TD]

[TD="class: xl64, width: 65, align: right"]35.1[/TD]

[TD="class: xl64, width: 65, align: right"]36.1[/TD]

[TD="class: xl64, width: 65, align: right"]36.6[/TD]

[TD="class: xl64, width: 65, align: right"]36.8[/TD]

[TD="class: xl64, width: 65, align: right"]37.0[/TD]

[TD="class: xl64, width: 65, align: right"][/TD]

[TD="class: xl64, width: 65, align: right"][/TD]

[TD="class: xl64, width: 65, align: right"][/TD]

[TD="class: xl64, width: 65, align: right"][/TD]

[TD="class: xl64, width: 65, align: right"][/TD]

[TD="class: xl64, width: 65, align: right"][/TD]

[TD="class: xl64, width: 65, align: right"][/TD]

[/TABLE]

I would like to find the last number in the row < 34 (i.e. the 33.7 in the 13th position)

Thanks to this forum, I already have a formula for finding the last minimum value in the row: =LOOKUP(1,1/(MIN(B2:AR2)=B2:AR2),ADDRESS(ROW(B2),COLUMN(B2:AR2),4))

As well as one for finding the FIRST number in the row < 34: =CELL("address",INDEX(B2:AR2,MATCH(TRUE,B2:AR2<=34,0)))

But I cannot seem to find a formula that will give me the last number in the row that is less than 34.

Thanks.