M
Mostropovich
It works - thanks. I was not to clear as for my task.
now from here, do you know how/if it would be possible to have the formula
working horizontally for more than one product and without having to add a
line every time sales or order are changed, e.g.:
from your original table:
Date sales opening order closing
01/01/2005 0 0 3 3
01/02/2005 0 3 1 4
01/03/2005 2 4 0 2
01/04/2005 3 2 1 0
01/05/2005 0 0 3 3
I would like to develop:
product1 sales opening order closing
0 0 3 3
product2 sales opening order closing
0 0 6 6
where just changing "sales" and/or "order", obtains the following result:
product1 sales opening order closing
2 3 0 1
product2 sales opening order closing
2 6 1 5
I tried (but I am very ignorant!) and I do not know how to avoid the loop
and create the incremental formula that I think is needed.
obviously if there is no answer to this, I will use your initial solution
and create very long lists, but I'd like to thank you again. let me know if I
can send you some flowers...
Giorgio
now from here, do you know how/if it would be possible to have the formula
working horizontally for more than one product and without having to add a
line every time sales or order are changed, e.g.:
from your original table:
Date sales opening order closing
01/01/2005 0 0 3 3
01/02/2005 0 3 1 4
01/03/2005 2 4 0 2
01/04/2005 3 2 1 0
01/05/2005 0 0 3 3
I would like to develop:
product1 sales opening order closing
0 0 3 3
product2 sales opening order closing
0 0 6 6
where just changing "sales" and/or "order", obtains the following result:
product1 sales opening order closing
2 3 0 1
product2 sales opening order closing
2 6 1 5
I tried (but I am very ignorant!) and I do not know how to avoid the loop
and create the incremental formula that I think is needed.
obviously if there is no answer to this, I will use your initial solution
and create very long lists, but I'd like to thank you again. let me know if I
can send you some flowers...
Giorgio