Hi there, I am currently in planning department and stuck with problem,which is to count cover of monthly stock in days vs demand.
Well I have looked in other response they have posted a code written in VBA but it covers +1 cell down or horizontaly, how ever I need smth like =monthcover(A2,B2:B12) covering all 12 month.
A B C
1stock on hand Demand stock cover
2 350 150 2...?
3 500 100
4 400 120
5
6
7
8
9
10
11
12