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