Excel - AVERAGE Function Problem - Expert Solution

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

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc