HI All
Another curly one that I cant seem to get my head around. I have a value (the value) in one cell, and I want that value to equal the value in another set of cells equal to the the amount of times (the multiplier) that is in a second cell.
Here is an example. The value “4” is in A1. The multiplier “5” is in A2. What I am trying to achieve is to have the value of “4” put into row 3 the amount of times equal to A2 (IE 5 times). Now I know I could do this manually, but I was wondering whether there was a way to do this automatically?
<tbody>
</tbody>
Any suggestions???
Thanks
Another curly one that I cant seem to get my head around. I have a value (the value) in one cell, and I want that value to equal the value in another set of cells equal to the the amount of times (the multiplier) that is in a second cell.
Here is an example. The value “4” is in A1. The multiplier “5” is in A2. What I am trying to achieve is to have the value of “4” put into row 3 the amount of times equal to A2 (IE 5 times). Now I know I could do this manually, but I was wondering whether there was a way to do this automatically?
| A | B | C | D | E | F | G |
1 | 4 | | | | | | |
2 | 5 | | | | | | |
3 | | 4 | 4 | 4 | 4 | 4 | |
<tbody>
</tbody>
Any suggestions???
Thanks