Thread: first value > 0
View Single Post
  #1   Report Post  
Ted Metro
 
Posts: n/a
Default 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