Locate first number that exceeds reference value
 

How can I find the first entry in a row of unsorted data that exceeds a
reference value, eg:

Reference Value: 45.57
Data: 45.54 45.56 45.32 45.5 45.42 45.35 45.61 45.4 44.97 45 45.65 44.55

The answer should be 7 (45.61)

Locate first number that exceeds reference value
 

Try...

=MATCH(TRUE,A1:L145.57,0)

and

=INDEX(A1:L1,MATCH(TRUE,A1:L145.57,0))

Both formulas need to be confirmed with CONTROL+SHIFT+ENTER, not just
ENTER. Adjust the range accordingly.

Hope this helps!

In article ,
"Nick Krill" wrote:

How can I find the first entry in a row of unsorted data that exceeds a
reference value, eg:

Reference Value: 45.57
Data: 45.54 45.56 45.32 45.5 45.42 45.35 45.61 45.4 44.97 45 45.65 44.55

The answer should be 7 (45.61)

Locate first number that exceeds reference value
 

On Thu, 5 Jan 2006 12:51:04 -0800, "Nick Krill"
wrote:

How can I find the first entry in a row of unsorted data that exceeds a
reference value, eg:

Reference Value: 45.57
Data: 45.54 45.56 45.32 45.5 45.42 45.35 45.61 45.4 44.97 45 45.65 44.55

The answer should be 7 (45.61)

You really should try to keep your threads together.

What was the matter with the response I posted last night?
--ron