solver how to get the average of 9 with 5 number

[jamiguel77]

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

 

[sandy666]

did you read post #7 ?!

here is for 5,6,7,8,9
with parts of the table because it has 1556 records

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

5​

[/td][td]

8​

[/td][td]

5​

[/td][td]

7​

[/td][td]

5​

[/td][td]

6​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

7​

[/td][td]

5​

[/td][td]

5​

[/td][td]

8​

[/td][td]

5​

[/td][td]

6​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

5​

[/td][td]

8​

[/td][td]

6​

[/td][td]

5​

[/td][td]

6​

[/td][td]

6​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

9​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

7​

[/td][td]

5​

[/td][td]

5​

[/td][td]

5​

[/td][td]

8​

[/td][td]

6​

[/td][/tr]
[/table]
[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][td=bgcolor:#E2EFDA]

7​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

6​

[/td][td]

6​

[/td][td]

8​

[/td][td]

10​

[/td][td]

5​

[/td][td]

7​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

6​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

9​

[/td][td=bgcolor:#E2EFDA]

7​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

7​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

6​

[/td][td]

5​

[/td][td]

9​

[/td][td]

6​

[/td][td]

9​

[/td][td]

7​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

9​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][td=bgcolor:#E2EFDA]

7​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

9​

[/td][td]

6​

[/td][td]

10​

[/td][td]

5​

[/td][td]

10​

[/td][td]

8​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

9​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

9​

[/td][td]

6​

[/td][td]

10​

[/td][td]

6​

[/td][td]

9​

[/td][td]

8​

[/td][/tr]
[/table]

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]

8​

[/td][td]

5​

[/td][td]

10​

[/td][td]

10​

[/td][td]

7​

[/td][td]

8​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

9​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

8​

[/td][td]

6​

[/td][td]

7​

[/td][td]

9​

[/td][td]

10​

[/td][td]

8​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][td=bgcolor:#E2EFDA]

7​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

9​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

10​

[/td][td]

8​

[/td][td]

10​

[/td][td]

10​

[/td][td]

7​

[/td][td]

9​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

9​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

9​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

10​

[/td][td]

10​

[/td][td]

8​

[/td][td]

10​

[/td][td]

7​

[/td][td]

9​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

9​

[/td][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

9​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

10​

[/td][td]

10​

[/td][td]

9​

[/td][td]

7​

[/td][td]

9​

[/td][td]

9​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

9​

[/td][td=bgcolor:#E2EFDA]

6​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

9​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

10​

[/td][td]

10​

[/td][td]

8​

[/td][td]

8​

[/td][td]

9​

[/td][td]

9​

[/td][/tr]
[/table]

[SIZE=1]let

    Source = {5,6,7,8,9,10},
    ToTable = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Add1 = Table.AddColumn(ToTable, "Custom", each Query2),
    Expand1 = Table.ExpandTableColumn(Add1, "Custom", {"Column1"}, {"Column1.1"}),
    Add2 = Table.AddColumn(Expand1, "Custom", each Query2),
    Expand2 = Table.ExpandTableColumn(Add2, "Custom", {"Column1"}, {"Column1.2"}),
    Add3 = Table.AddColumn(Expand2, "Custom", each Query2),
    Expand3 = Table.ExpandTableColumn(Add3, "Custom", {"Column1"}, {"Column1.3"}),
    Add4 = Table.AddColumn(Expand3, "Custom", each Query2),
    Expand4 = Table.ExpandTableColumn(Add4, "Custom", {"Column1"}, {"Column1.4"}),
    Average = Table.AddColumn(Expand4, "Average", each List.Average({[Column1], [Column1.1], [Column1.2], [Column1.3], [Column1.4]}), type number),
    ChTpText = Table.TransformColumnTypes(Average,{{"Average", type text}}),
    FilterDot = Table.SelectRows(ChTpText, each not Text.Contains([Average], ".")),
    CHTpNum = Table.TransformColumnTypes(FilterDot,{{"Average", Int64.Type}}),
    SortAsc = Table.Sort(CHTpNum,{{"Average", Order.Ascending}})
in
    SortAsc[/SIZE]

in PowerQuery Editor open Advanced Editor and paste code copied from here

 

[jamiguel77]

ooo is power Query...

reading: https://www.howtoexcel.org/power-query/m-code/
if can share tutorials, and second code....

Thanks

 

[jamiguel77]

ok sorry not readed the post7 completly...

thanks

 

[sandy666]

I forgot...
first you need do this, name it as Query2

[SIZE=1]
let
    Source = {5,6,7,8,9,10},
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
    #"Converted to Table"[/SIZE]

then post above (#11)

 

[sandy666]

you need to decide which one is correct for you because they are completly different

 

[jamiguel77]

@sandy666 not luck, downloaded power query, installed, and tell me Excel 2016 have power query, i go to data tab, but not see..

how to activate it?

thanks

 

[sandy666]

what real version of excel do you have?