Forum Discussion

Todd Benedict's avatar
Todd Benedict
Copper Contributor
Nov 03, 2018

Find the closest 3 averages in a range of 21 values

I'm trying to determine the fairest 3 man teams for next season's league by averaging the performance numbers of 21 players and seeing which 3 numbers are most equal, creating the fairest teams. The ...
excel
Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Nov 04, 2018
wouldn't sorting them in descending (largest to smallest) order give you the top 3 in the list?
  • Todd Benedict's avatar
    Todd Benedict
    Copper Contributor
    Nov 04, 2018

    Thanks for the response. The average for the below scores per player is 86.2, or for a 3 man team the average is 258.6. What I'd like to do is find the 3 matches that come closest to this average to determine the fairest teams for next year. For example, the best player would have to be paired with the two worst players with the scores

     

    355.87

    15.34

    8.9

     

    I would like to find all other 3 player score combinations that come closest to the average to find the fairest teams

     

    Here are the scores without decimals in descending order. Does this make sense?

     

    356
    236
    212
    170
    142
    109
    103
    94
    57
    40
    40
    34
    33
    33
    32
    30
    26
    23
    16
    15
    9
    • Lorenzo Kim's avatar
      Lorenzo Kim
      Bronze Contributor
      Nov 04, 2018

      if your criteria would be pairing the highest with the two lowest,

      pls see attached file.

      hope that this is what your're looking for.

      thanks..

      • Todd Benedict's avatar
        Todd Benedict
        Copper Contributor
        Nov 05, 2018

        Thanks, Lorenzo. That seems about right. Can you advise what formula is used to show these numbers? So I know for the future. Thanks again for your help!

Resources