Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|