Evaluate a Range

  • Thread starter Thread starter ASPENCO
  • Start date Start date
A

ASPENCO

I would like to create a formula that looks at a range with a specified
criterion and when it finds the first entry in that range that meets
that criterion returns the position of that data in the range. For
example, given the following data beginning in A1 and extending to D1:

5,7 ,8,11

I would like to create a formula that looks for a value greater than 10
in that range and then returns the number 4 to signify that it is the
fourth entry in that range. Thanks as always for your help.
 
One way:

Array enter (CTRL-SHIFT-ENTER or CMD-RETURN):

=MATCH(TRUE,(A1:D1>10),FALSE)

If it's possible that no values are >10:

=IF(MAX(A1:D1)<=10,"",MATCH(TRUE,(A1:D1>10),FALSE))
 
Back
Top