| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Finding last value greater than 0
In A1:L1 I have January through December
In A2:L2 I have -- 200 -- A2 0 -- B2 150 225 0 0 300 400 0 600 0 0 -- L2 To find the first month in which sales are greater than 250 I use this formula entered as an array - index(A1:L1,match(true,A2:L2250,0)) What formula can I use to find the last month in which sales were greater than 0, in this example it will be October (600 units)? Can I modify my existing formula? Thank you for any help! Ted |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup finding the next value that is GREATER | Excel Worksheet Functions | |||
| vlookup - finding the next value that is GREATER than the lookup value? | Excel Worksheet Functions | |||
| if greater then 99 then 1 if greater then 199 then two | Excel Worksheet Functions | |||
| Help w/ SUMIF ; INDEX | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Threaded Mode
