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