Locate first number that exceeds reference value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Try...

=MATCH(TRUE,A1:L1>45.57,0)

and

=INDEX(A1:L1,MATCH(TRUE,A1:L1>45.57,0))

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

Hope this helps!
 
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)
Click to expand...

You really should try to keep your threads together.

What was the matter with the response I posted last night?
--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Step through a row of data 1
Find the closest match to a reference number in a row of unsorted 3
Find first threshold violation 3
Return cell referance of the first cell that equals a value? 5
Return SEARCHED Column Number of Numeric Label and Value 23
data sort while maintining reference with cell in different worksh 1
Can this be done using Sumproduct? 1
VLOOKUP Function returning multiple values in a separate table 8

Back
Top