Excel Lowest and Highest

[window15]

Hi

Can anyone help

this can you find the lowest nunber before a number is above the end column 3.75

so row 1 end column -3,75 , lowest is 3.55 befor 1st colunn over3.75 which is 4

is there a formula for this

cheers

Akab

 

[Fluff]

Hi & welcome to MrExcel.
How about like

=MIN(INDEX(B2:O2,XMATCH(O2+0.005,B2:O2,1)):O2)