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

Hlp! Named range Advanced Filter Criterion 10
sum last 3 numbers greater that 0 in a range 0
Looking up a returned value defining a named range 2
Reporting from data into grouped ranges.. 1
Excel VBA 1
Copying a split range 3
Counting cells using EVALUATE 5
Help With MS Access 4

Back
Top