Formula Help Needed please

[feefona]

Hi, I need some help with a formula.

I have a table with values per month and an in stock quantity. Has anyone any idea if you can use a formula to give you the month in which the stock will run out? I.e. ROW 1, the stock will run out in "Oct 19" - is there any calculation that will provide you with the month without having to calculate it manually? Its a document with quite a few lines so can be very time consuming?

	A	B	C	D	E	F
1	Aug 19	Sept 19	Oct 19	Nov 19	Dec 19	In Stock
2	1500	1500	1000	1000	500	3500
3	500	600	600	500	500	3000
4	500	500	200	200	200	759

<tbody>
</tbody>

Many thanks in advance

 

[Peter_SSs]

Welcome to the MrExcel Board!

Something like this, copied down?

Excel Workbook
	A	B	C	D	E	F	G
1	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19	In Stock	Expires
2	1500	1500	1000	1000	500	3500	Oct-19
3	500	600	600	500	500	3000	Sufficient Stock
4	500	500	200	200	200	759	Sep-19
Stock Expiry

 

[feefona]

Hi Peter, this is exactly what I need. Thank you so much, your help is really, really appreciated ?

 

[Peter_SSs]

Hi Peter, this is exactly what I need. Thank you so much, your help is really, really appreciated &#55357;&#56842;

You're welcome. Thanks for the follow up.

 

[Tbom1911]

Welcome to the MrExcel Board!

Something like this, copied down?

Excel Workbook
	A	B	C	D	E	F	G
1	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19	In Stock	Expires
2	1500	1500	1000	1000	500	3500	Oct-19
3	500	600	600	500	500	3000	Sufficient Stock
4	500	500	200	200	200	759	Sep-19
Stock Expiry

Hi Peter. I hope you don’t mind me messaging you but I was wondering if there was any chance you could look at my most recent post. I just joined this forum today because I’m struggling with something similar and would mean the world if you could help me as I’m struggling a lot with excel.