Sorry if the title is confusing..
So I am creating a spreadsheet for a series of last-time buy parts that are going to run out in a certain number of months depending on consumption. I have created a timeline that shows quantity on hand at any given month for a series of parts (I have attatched a pic for reference.) On a seperate sheet, I want to create a formula that will display the Month corresponding to the negative number in each row.LTBspreadsheet.jpg
If someone could help me out, it would be much appreciated!
Thanks in advance!
jmaranian
Bookmarks