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?

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Aug 19[/TD]
[TD]Sept 19[/TD]
[TD]Oct 19[/TD]
[TD]Nov 19[/TD]
[TD]Dec 19[/TD]
[TD]In Stock[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1500[/TD]
[TD]1500[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]500[/TD]
[TD]3500[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]500[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]3000[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]759[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.