Hi Excel Masters,
I would like to be able to list all the possibilities in a column of the following :
- If I have a qity of X in A1, I would like to be able to create a serie of possibilities of this qty to be dispacthed in A2 and A3 in column A as per below example... This will have to be working even with qty >0 in A2 and A3
Example
Starting position is 2 in A1 and 0 in A2 and A3 , and i would need those 2 to be sent to A3 and A4 and so on depending on X in A1 with all possibilities in the same column as below..
Any help would be greatly appreciated... Thanks in advance
Before MACro or Formula
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
After MACro or Formula
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
I would like to be able to list all the possibilities in a column of the following :
- If I have a qity of X in A1, I would like to be able to create a serie of possibilities of this qty to be dispacthed in A2 and A3 in column A as per below example... This will have to be working even with qty >0 in A2 and A3
Example
Starting position is 2 in A1 and 0 in A2 and A3 , and i would need those 2 to be sent to A3 and A4 and so on depending on X in A1 with all possibilities in the same column as below..
Any help would be greatly appreciated... Thanks in advance
Before MACro or Formula
A1 | 2 |
A2 | 0 |
A3 | 0 |
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
After MACro or Formula
A1 | 2 |
A2 | 0 |
A3 | 0 |
A4 | 1 |
A5 | 1 |
A6 | 0 |
A7 | 0 |
A8 | 1 |
A9 | 1 |
A10 | 0 |
A11 | 0 |
A12 | 2 |
A13 | 0 |
A14 | 2 |
A15 | 0 |
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>