Use a specific set of numbers x times to equal a set value

Anthea

New Member
Joined
Apr 5, 2011
Messages
13
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 :eek:) ...
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
ABCDEF
1Values RequiredRequired totalNumber of values to be output to Col ANumbers to use
2359722110
318
420
521
622
723
826
930
1031
1132
1236
1338
1440
1542
1650
1753
1854
1955
2056
2166
2267
2368
2469
2570
2674
2776
2881
2982
3084
3190
3292
33100
34102
35106
36110
37114
38116
39118
40132
41134
42138
43140
44144
45146
46152
47
48

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Do you mean something like this? (There are more than two possibilities):


Book1
ABC
1No of timesNumberTotal
2172183,096
34810480
412121
52213,597
6
7No of timesNumberTotal
8201102,010
911818
1017811,377
1119292
121100100
132213,597
Sheet1


Are you looking for a solution to this specific problem? All possible solutions? Or the solution(s) to a more general problem?

Assuming I have interpreted correctly, this specific example is relatively easy, as 3,597/221 = approximately 16 on average, which is almost at the end of your list of numbers. If you choose a total bigger than 3,597, it may become impractical to test all possible combinations.
 
Upvote 0

Forum statistics

Threads
1,213,564
Messages
6,114,334
Members
448,567
Latest member
Kuldeep90

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top