Question description:
This user has given permission to use the problem statement for this
blog.
I have a table with 8 values in it. I am trying to split the table into 2 groups with the lowest average difference between them.
Solved by G. E. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
19/08/2018 - 04:33
Welcome to ExcelChat!
Excelchat Expert
19/08/2018 - 04:34
Could you show your data and explain what you want to achieve?
User
19/08/2018 - 04:34
yes i am going to upload
User
19/08/2018 - 04:34
https://docs.google.com/spreadsheets/d/1jced__gp5BJWxbaxUONjvF4pzSVuzKMD9P2f-GEOaLk/edit?usp=sharing
User
19/08/2018 - 04:36
I am trying to get B2:B5 and F2:F5 average from the B13:B20 table with the lowest average difference
Excelchat Expert
19/08/2018 - 04:36
Could you show the desired example of the output?
Excelchat Expert
19/08/2018 - 04:38
Oh.. so you want to match the players in the way that there averages would as similar as possible?
User
19/08/2018 - 04:38
yeah
User
19/08/2018 - 04:38
That way they have the smallest difference in glory
User
19/08/2018 - 04:38
between the 2 groups
Excelchat Expert
19/08/2018 - 04:39
Okay, I got your task.. will think of the possible solution
User
19/08/2018 - 04:40
yeah i am just glad i managed to get everything else to work lol
Excelchat Expert
19/08/2018 - 04:41
Could you give me the access to edit your book?
User
19/08/2018 - 04:41
may take a sec don't use this that often so have to find how
User
19/08/2018 - 04:45
https://drive.google.com/file/d/1NRZJw8kKuCheWR2wlokfdfVBUW-ox6lw/view?usp=sharing
[Uploaded an Excel file]
User
19/08/2018 - 04:45
got it
User
19/08/2018 - 04:45
link that allows edits
Excelchat Expert
19/08/2018 - 04:45
Thank you
User
19/08/2018 - 04:46
np sry it took so long to figure out
Excelchat Expert
19/08/2018 - 04:48
When you see the pop up, please extend the session
User
19/08/2018 - 04:49
sry just meant to click
User
19/08/2018 - 05:01
best difference i manages so far is 91.75
Excelchat Expert
19/08/2018 - 05:09
Could you please extend the session one more time?
User
19/08/2018 - 05:10
yup :)
User
19/08/2018 - 05:10
I am very good at being difficult and i guess this is no difference lol
Excelchat Expert
19/08/2018 - 05:29
What is the combination to get difference of 91?
User
19/08/2018 - 05:29
added into the sheet we next tot eh chat
User
19/08/2018 - 05:30
23,5500,2659,685 and 1829,1526,3500,1645
Excelchat Expert
19/08/2018 - 05:30
Oh, you have averages
Excelchat Expert
19/08/2018 - 05:30
I used sum
Excelchat Expert
19/08/2018 - 05:30
Look, I have created all kind of combinations
Excelchat Expert
19/08/2018 - 05:31
The table with the closest value to 0 is the solution
Excelchat Expert
19/08/2018 - 05:32
I don't have enough time to link the final result to them.. sorry, the task is quite hard for me, I believe there should be applied some special formula from math
User
19/08/2018 - 05:32
np i will figure it out
Excelchat Expert
19/08/2018 - 05:32
But my tables show the same
Excelchat Expert
19/08/2018 - 05:32
91.75 is the smallest difference
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.