Finding the first number larger than ....

Hi,

I can solve this using code, a UDF or a helper column but if possible I'd like to tidy it up by using a formula. I think it'll probably be an array formula of some kind but that's not my strong point.

Here goes:

A range, say A1 thru A20 is populated with numbers in a random order.
Cell C1 has a threshold number.

What I'd like to know is the number of the entry in the list that first breaches the threshold. So for example, the 11th entry is the first above the threshold.

Can anyone help?
Thanks

Gary

Not even an array formula

=INDEX(A1:A20,MATCH(TRUE,INDEX(A1:A20>C1,0),))

Sweet, thanks Bob.

Finds the first value above the threshold; wrap it all in a MATCH and I've got the location. :)

It's the snippets that make all the difference like, in this case, knowing you can put a condition in an INDEX and match on the test against the condition.
Very useful to know!

Also not the usage of 0 as an argument to the INDEX function, that means that INDEX returns an array of values.