Re: Identify First number in row that is less than or equal to x
Perfect. Thanks a million.
Re: Identify First number in row that is less than or equal to x
Perfect. Thanks a million.
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))
Don’t have an account yet? Register yourself now and be a part of our community!