Identify First number in row that is less than or equal to x

Re: Identify First number in row that is less than or equal to x

You are welcome.

Re: Identify First number in row that is less than or equal to x

good stuff Robert Mika

Re: Identify First number in row that is less than or equal to x

Thank you pike.
(would rather use your real name,..)

Re: Identify First number in row that is less than or equal to x

me real name is OK either or ..just dont call me late for lunch

thinking
for non-array
=INDIRECT(ADDRESS(1,MATCH(TRUE,INDEX((A1:L1<=34),0),0),4))

Peter

Re: Identify First number in row that is less than or equal to x

or
non arrayformula
=INDEX(A1:L1,MATCH(TRUE,INDEX((A1:L1<=34),0),0))