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