Hello
Please could someone help me to do this (I have searched the internet and found nothing or more than likely, am not using the correct terminology ) ...
I want to use the numbers in Column F the D2 number of times to Equal C2 (or at least as close to it as possible if the actual figure is not attainable)
i.e. Use the numbers in Column F 221 times to equal 3597 (or at least as close to it as possible if the actual figure is not attainable)Any help will be much appreciatedRegards
Anthea
Excel 2016 (Windows) 32 bit
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Please could someone help me to do this (I have searched the internet and found nothing or more than likely, am not using the correct terminology ) ...
I want to use the numbers in Column F the D2 number of times to Equal C2 (or at least as close to it as possible if the actual figure is not attainable)
i.e. Use the numbers in Column F 221 times to equal 3597 (or at least as close to it as possible if the actual figure is not attainable)Any help will be much appreciatedRegards
Anthea
Excel 2016 (Windows) 32 bit
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Values Required | Required total | Number of values to be output to Col A | Numbers to use | ||
2 | 3597 | 221 | 10 | |||
3 | 18 | |||||
4 | 20 | |||||
5 | 21 | |||||
6 | 22 | |||||
7 | 23 | |||||
8 | 26 | |||||
9 | 30 | |||||
10 | 31 | |||||
11 | 32 | |||||
12 | 36 | |||||
13 | 38 | |||||
14 | 40 | |||||
15 | 42 | |||||
16 | 50 | |||||
17 | 53 | |||||
18 | 54 | |||||
19 | 55 | |||||
20 | 56 | |||||
21 | 66 | |||||
22 | 67 | |||||
23 | 68 | |||||
24 | 69 | |||||
25 | 70 | |||||
26 | 74 | |||||
27 | 76 | |||||
28 | 81 | |||||
29 | 82 | |||||
30 | 84 | |||||
31 | 90 | |||||
32 | 92 | |||||
33 | 100 | |||||
34 | 102 | |||||
35 | 106 | |||||
36 | 110 | |||||
37 | 114 | |||||
38 | 116 | |||||
39 | 118 | |||||
40 | 132 | |||||
41 | 134 | |||||
42 | 138 | |||||
43 | 140 | |||||
44 | 144 | |||||
45 | 146 | |||||
46 | 152 | |||||
47 | ||||||
48 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2