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
|