Forum Discussion
Solved
Formular needed for "periods until sold out"
Hey,
I need your help to find the right formular for this problem. I want it to give out the number of the column of the period in which a specific product is out of stock.
In the example: For product 1 column no. 12 and for product 2 column no. 7.
Thanks in advance!
| Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Stock product 1 | 700 | 625 | 550 | 475 | 400 | 325 | 250 | 175 | 100 | 25 | -50 | -125 |
| Stock product 2 | 1400 | 1040 | 1024 | 626 | 189 | -292 | -821 | -1403 | -2044 | -2748 | -3523 | -4375 |
| In which period is product 1 sold out? | ??? | |||||||||||
| In which period is product 2 sold out? | ??? |
5 Replies
What is the logic behind, why column 12, not 11?
- You are right, my mistake!
It must be the number of the period
