first value > 0
 

If I have a list of numbers in b2:G2 and months of the year above in b1:g1
what formula can I enter that will display the first month in which a value
is greater than 10.

like so --

jan feb mar apr ...
apples 10 8 12 15

First month greater than 10 is march.

Ted

=index(b$1:g$1,match(true,b2:g210,0))
array entered (ctrl+shift+enter)

"Ted Metro" wrote in message
...
If I have a list of numbers in b2:G2 and months of the year above in b1:g1
what formula can I enter that will display the first month in which a
value
is greater than 10.

like so --

jan feb mar apr ...
apples 10 8 12 15

First month greater than 10 is march.

Ted