3 consecutive months reporting volumes in a row

[ginger123]

I want to know how to write a formula for last productiondate; if the well has produced for 3 consecutive months it would put the datein the box for me….
I have 10 years worth of data and it will need to pick the most recent - 3 consecutive month production date...if that makes sense!?!?
Any help would be much appreciated!!!

Example:

Well ID	Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Sep-17	Oct-17	Nov-17	Dec-17	Last production date
Well A	15	20	15			10	10		15			25	Mar-17
Well B	4	2			5	7	8			15		5	Jul-17
Well C				10	10	10							Jun-17

<tbody>
</tbody>

 

[Tetra201]

Try

=LOOKUP(2,1/($B2:$K2<>"")/($C2:$L2<>"")/($D2:$M2<>""),$D$1:$M$1)

 

[ginger123]

Try

 

[ginger123]

Try

=LOOKUP(2,1/($B2:$K2<>"")/($C2:$L2<>"")/($D2:$M2<>""),$D$1:$M$1)

Thanks for your reply!
So I tried it and it just comes up with Dec 17 on all 3 rows. I would like it to return the most recent consecutive 3 month production...

Well ID	Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Sep-17	Oct-17	Nov-17	Dec-17	Last production date
Well A	15	20	15	0	0	10	10	0	15	0	0	25	Mar-17
Well B	4	2	0	0	5	7	8	0	0	15	0	5	Jul-17
Well C	10	10	10	0	0	10	10	10	0	0	0	0	Aug-17

<colgroup><col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;"> <col width="64" style="width: 48pt;" span="2"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="64" style="width: 48pt;"> <col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;"> <col width="64" style="width: 48pt;" span="2"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="64" style="width: 48pt;" span="2"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="64" style="width: 48pt;"> <col width="148" style="width: 111pt; mso-width-source: userset; mso-width-alt: 5412;"> <col width="64" style="width: 48pt;"> <tbody> </tbody>

 

[Tetra201]

That's because now you have zeros in your dataset, whereas in Post # 1 you had blank cells instead.

The following formula has been tested to return the expected results for the dataset from Post # 4:

=LOOKUP(2,1/($B2:$K2>0)/($C2:$L2>0)/($D2:$M2>0),$D$1:$M$1)

 

[ginger123]

Thank you!!