circularloop
New Member
- Joined
- Jan 28, 2016
- Messages
- 7
Hello guys,
Looking some help in excel formula (not macros). I have group of units based on their sizes. e.g. type X=2 units, type Y=1 units, Z=3 units and so on filled in excel as below;
<tbody>
</tbody>
so based on the value in column B as above, I want all rows beyond 5 to populate/list each item repetitively as following;
<tbody>
</tbody>
any help on this is greatly appreciated.
Looking some help in excel formula (not macros). I have group of units based on their sizes. e.g. type X=2 units, type Y=1 units, Z=3 units and so on filled in excel as below;
A | B | |
1 | X | 2 |
2 | Y | 1 |
3 | Z | 3 |
<tbody>
</tbody>
so based on the value in column B as above, I want all rows beyond 5 to populate/list each item repetitively as following;
5 | 1 | X |
6 | 2 | X |
7 | 1 | Y |
8 | 1 | Z |
9 | 2 | Z |
10 | 3 | Z |
<tbody>
</tbody>
any help on this is greatly appreciated.