# solver how to get the average of 9 with 5 number

#### jamiguel77

##### Active Member
Hi friends i have this numbers:

5,6,7,8,9,10

wich is the combinations of these numbers that give me an average of 9, (the numbers can repeated)

sample:

9+9+9+9+9= 45 / 5 = 9
10+10+10+7+8 = 45 / 5 = 9
10+10+9+8+8= 45 / 5 = 9

and with 5 numbers wich combination of numbers that give eman average of 8
and with 5 numbers wich combination of numbers that give eman average of 7
and with 5 numbers wich combination of numbers that give eman average of 6
and with 5 numbers wich combination of numbers that give eman average of 5

thanks

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

how can I make a combination of these numbers to achieve an average of 9, note the numbers can repeat, sample:

9+9+9+9+9= 45 / 5 = 9
10+10+10+7+8 = 45 / 5 = 9
10+10+9+8+8= 45 / 5 = 9

thanks

you mean something like this?

 Column1 Column1.1 Column1.2 Column1.3 Column1.4 Addition 5​ 10​ 10​ 10​ 10​ 45​ 6​ 9​ 10​ 10​ 10​ 45​ 6​ 10​ 9​ 10​ 10​ 45​ 6​ 10​ 10​ 9​ 10​ 45​ 6​ 10​ 10​ 10​ 9​ 45​ 7​ 8​ 10​ 10​ 10​ 45​ 7​ 9​ 9​ 10​ 10​ 45​ 7​ 9​ 10​ 9​ 10​ 45​ 7​ 9​ 10​ 10​ 9​ 45​ 7​ 10​ 8​ 10​ 10​ 45​ 7​ 10​ 9​ 9​ 10​ 45​ 7​ 10​ 9​ 10​ 9​ 45​ 7​ 10​ 10​ 8​ 10​ 45​ 7​ 10​ 10​ 9​ 9​ 45​ 7​ 10​ 10​ 10​ 8​ 45​ 8​ 7​ 10​ 10​ 10​ 45​ 8​ 8​ 9​ 10​ 10​ 45​ 8​ 8​ 10​ 9​ 10​ 45​ 8​ 8​ 10​ 10​ 9​ 45​ 8​ 9​ 8​ 10​ 10​ 45​ 8​ 9​ 9​ 9​ 10​ 45​ 8​ 9​ 9​ 10​ 9​ 45​ 8​ 9​ 10​ 8​ 10​ 45​ 8​ 9​ 10​ 9​ 9​ 45​ 8​ 9​ 10​ 10​ 8​ 45​ 8​ 10​ 7​ 10​ 10​ 45​ 8​ 10​ 8​ 9​ 10​ 45​ 8​ 10​ 8​ 10​ 9​ 45​ 8​ 10​ 9​ 8​ 10​ 45​ 8​ 10​ 9​ 9​ 9​ 45​ 8​ 10​ 9​ 10​ 8​ 45​ 8​ 10​ 10​ 7​ 10​ 45​ 8​ 10​ 10​ 8​ 9​ 45​ 8​ 10​ 10​ 9​ 8​ 45​ 8​ 10​ 10​ 10​ 7​ 45​ 9​ 6​ 10​ 10​ 10​ 45​ 9​ 7​ 9​ 10​ 10​ 45​ 9​ 7​ 10​ 9​ 10​ 45​ 9​ 7​ 10​ 10​ 9​ 45​ 9​ 8​ 8​ 10​ 10​ 45​ 9​ 8​ 9​ 9​ 10​ 45​ 9​ 8​ 9​ 10​ 9​ 45​ 9​ 8​ 10​ 8​ 10​ 45​ 9​ 8​ 10​ 9​ 9​ 45​ 9​ 8​ 10​ 10​ 8​ 45​ 9​ 9​ 7​ 10​ 10​ 45​ 9​ 9​ 8​ 9​ 10​ 45​ 9​ 9​ 8​ 10​ 9​ 45​ 9​ 9​ 9​ 8​ 10​ 45​ 9​ 9​ 9​ 9​ 9​ 45​ 9​ 9​ 9​ 10​ 8​ 45​ 9​ 9​ 10​ 7​ 10​ 45​ 9​ 9​ 10​ 8​ 9​ 45​ 9​ 9​ 10​ 9​ 8​ 45​ 9​ 9​ 10​ 10​ 7​ 45​ 9​ 10​ 6​ 10​ 10​ 45​ 9​ 10​ 7​ 9​ 10​ 45​ 9​ 10​ 7​ 10​ 9​ 45​ 9​ 10​ 8​ 8​ 10​ 45​ 9​ 10​ 8​ 9​ 9​ 45​ 9​ 10​ 8​ 10​ 8​ 45​ 9​ 10​ 9​ 7​ 10​ 45​ 9​ 10​ 9​ 8​ 9​ 45​ 9​ 10​ 9​ 9​ 8​ 45​ 9​ 10​ 9​ 10​ 7​ 45​ 9​ 10​ 10​ 6​ 10​ 45​ 9​ 10​ 10​ 7​ 9​ 45​ 9​ 10​ 10​ 8​ 8​ 45​ 9​ 10​ 10​ 9​ 7​ 45​ 9​ 10​ 10​ 10​ 6​ 45​ 10​ 5​ 10​ 10​ 10​ 45​ 10​ 6​ 9​ 10​ 10​ 45​ 10​ 6​ 10​ 9​ 10​ 45​ 10​ 6​ 10​ 10​ 9​ 45​ 10​ 7​ 8​ 10​ 10​ 45​ 10​ 7​ 9​ 9​ 10​ 45​ 10​ 7​ 9​ 10​ 9​ 45​ 10​ 7​ 10​ 8​ 10​ 45​ 10​ 7​ 10​ 9​ 9​ 45​ 10​ 7​ 10​ 10​ 8​ 45​ 10​ 8​ 7​ 10​ 10​ 45​ 10​ 8​ 8​ 9​ 10​ 45​ 10​ 8​ 8​ 10​ 9​ 45​ 10​ 8​ 9​ 8​ 10​ 45​ 10​ 8​ 9​ 9​ 9​ 45​ 10​ 8​ 9​ 10​ 8​ 45​ 10​ 8​ 10​ 7​ 10​ 45​ 10​ 8​ 10​ 8​ 9​ 45​ 10​ 8​ 10​ 9​ 8​ 45​ 10​ 8​ 10​ 10​ 7​ 45​ 10​ 9​ 6​ 10​ 10​ 45​ 10​ 9​ 7​ 9​ 10​ 45​ 10​ 9​ 7​ 10​ 9​ 45​ 10​ 9​ 8​ 8​ 10​ 45​ 10​ 9​ 8​ 9​ 9​ 45​ 10​ 9​ 8​ 10​ 8​ 45​ 10​ 9​ 9​ 7​ 10​ 45​ 10​ 9​ 9​ 8​ 9​ 45​ 10​ 9​ 9​ 9​ 8​ 45​ 10​ 9​ 9​ 10​ 7​ 45​ 10​ 9​ 10​ 6​ 10​ 45​ 10​ 9​ 10​ 7​ 9​ 45​ 10​ 9​ 10​ 8​ 8​ 45​ 10​ 9​ 10​ 9​ 7​ 45​ 10​ 9​ 10​ 10​ 6​ 45​ 10​ 10​ 5​ 10​ 10​ 45​ 10​ 10​ 6​ 9​ 10​ 45​ 10​ 10​ 6​ 10​ 9​ 45​ 10​ 10​ 7​ 8​ 10​ 45​ 10​ 10​ 7​ 9​ 9​ 45​ 10​ 10​ 7​ 10​ 8​ 45​ 10​ 10​ 8​ 7​ 10​ 45​ 10​ 10​ 8​ 8​ 9​ 45​ 10​ 10​ 8​ 9​ 8​ 45​ 10​ 10​ 8​ 10​ 7​ 45​ 10​ 10​ 9​ 6​ 10​ 45​ 10​ 10​ 9​ 7​ 9​ 45​ 10​ 10​ 9​ 8​ 8​ 45​ 10​ 10​ 9​ 9​ 7​ 45​ 10​ 10​ 9​ 10​ 6​ 45​ 10​ 10​ 10​ 5​ 10​ 45​ 10​ 10​ 10​ 6​ 9​ 45​ 10​ 10​ 10​ 7​ 8​ 45​ 10​ 10​ 10​ 8​ 7​ 45​ 10​ 10​ 10​ 9​ 6​ 45​ 10​ 10​ 10​ 10​ 5​ 45​

or like this

 5+ 10+ 10+ 10+ 10 45​ 6+ 9+ 10+ 10+ 10 45​ 7+ 8+ 10+ 10+ 10 45​ 7+ 9+ 9+ 10+ 10 45​ 8+ 8+ 9+ 10+ 10 45​ 8+ 9+ 9+ 9+ 10 45​ 9+ 9+ 9+ 9+ 9 45​

@sandy666 yes... but wich is the forumla?

i want generate too:

and with 5 numbers wich combination of numbers that give me an average of 8
and with 5 numbers wich combination of numbers that give me an average of 7
and with 5 numbers wich combination of numbers that give me an average of 6
and with 5 numbers wich combination of numbers that give me an average of 5

Thanks

I understand "yes" but I don't know which one

and this is PowerQuery not a formula or vba or even not a solver

like me more the first answer, large table.

Thanks

here is a M-code for table from post #4

Code:
``````[SIZE=1]let

Source = {5,6,7,8,9,10},
ToTable = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
Expand1 = Table.ExpandTableColumn(Add1, "Custom", {"Column1"}, {"Column1.1"}),
Expand2 = Table.ExpandTableColumn(Add2, "Custom", {"Column1"}, {"Column1.2"}),
Expand3 = Table.ExpandTableColumn(Add3, "Custom", {"Column1"}, {"Column1.3"}),
Expand4 = Table.ExpandTableColumn(Add4, "Custom", {"Column1"}, {"Column1.4"}),
Sum = Table.AddColumn(Expand4, "Addition", each List.Sum({[Column1], [Column1.1], [Column1.2], [Column1.3], [Column1.4]}), type number),
Filter45 = Table.SelectRows(Sum, each [Addition] = 45)
in
Filter45[/SIZE]``````

Last edited:
this code where i put?

in VBA?

and if possible second solution post#5 how to?

thanks

Replies
7
Views
166
Replies
3
Views
134
Replies
18
Views
596
Replies
3
Views
107
Replies
4
Views
168

1,203,115
Messages
6,053,598
Members
444,674
Latest member
DWriter9

### 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.

### Which adblocker are you using?

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

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