Spreadsheet: 869669d1716280940-help-with-selecting-volleyball-or-any-sport-teams-with-equal-skill-divide-players-into-teams-of-equal-skill
Sheet: JT

 |  |  |  | # Players /Team | # [NAME] | Total # Players | Average Skill Level |  | Note |  |  |  |  |  | Help with selecting volleyball (or any sport) teams with equal skill
 | Total # players |  |  |  |  |  |  |  | 1)  Table1 sorted in "Skill Level" descending order |  |  |  |  |  | https://www.excelforum.com/excel-general/1424127-help-with-selecting-volleyball-or-any-sport-teams-with-equal-skill.html
 | Total # teams |  | 16 |  |  |  |  |  | 2)  9 to 12 players per team
 | # | Player | Skill Level | Rank | Team | Rank in Team | Team + Rank |  | Team | # Players | Total Skill Level | Average Skill Level |  | Team | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | P001 | 4.973
 |  | P002 | 4.973
 |  | P003 | 4.973
 |  | P004 | 4.94
 |  | P005 | 4.927
 |  | P006 | 4.921
 |  | P007 | 4.855
 |  | P008 | 4.801
 |  | P009 | 4.799
 |  | P010 | 4.799
 |  | P011 | 4.799
 |  | P012 | 4.771
 |  | P013 | 4.752
 |  | P014 | 4.734
 |  | P015 | 4.722
 |  | P016 | 4.701
 |  | P017 | 4.684
 |  | P018 | 4.672
 |  | P019 | 4.659
 |  | P020 | 4.65
 |  | P021 | 4.632
 |  | P022 | 4.628
 |  | P023 | 4.612
 |  | P024 | 4.602
 |  | P025 | 4.581
 |  | P026 | 4.575
 |  | P027 | 4.553
 |  | P028 | 4.55
 |  | P029 | 4.526
 |  | P030 | 4.486
 |  | P031 | 4.478
 |  | P032 | 4.471
 |  | P033 | 4.46
 |  | P034 | 4.439
 |  | P035 | 4.423
 |  | P036 | 4.42
 |  | P037 | 4.413
 |  | P038 | 4.369
 |  | P039 | 4.356
 |  | P040 | 4.338
 |  | P041 | 4.338
 |  | P042 | 4.338
 |  | P043 | 4.313
 |  | P044 | 4.311
 |  | P045 | 4.254
 |  | P046 | 4.247
 |  | P047 | 4.245
 |  | P048 | 4.236
 |  | P049 | 4.222
 |  | P050 | 4.214
 |  | P051 | 4.192
 |  | P052 | 4.161
 |  | P053 | 4.13
 |  | P054 | 4.097
 |  | P055 | 4.077
 |  | P056 | 4.053
 |  | P057 | 4.043
 |  | P058 | 4.031
 |  | P059 | 4.026
 |  | P060 | 4.026
 |  | P061 | 4.013
 |  | P062 | 3.998
 |  | P063 | 3.962
 |  | P064 | 3.928
 |  | P065 | 3.903
 |  | P066 | 3.899
 |  | P067 | 3.874
 |  | P068 | 3.873
 |  | P069 | 3.871
 |  | P070 | 3.835
 |  | P071 | 3.817
 |  | P072 | 3.806
 |  | P073 | 3.803
 |  | P074 | 3.802
 |  | P075 | 3.798
 |  | P076 | 3.791
 |  | P077 | 3.767
 |  | P078 | 3.757
 |  | P079 | 3.757
 |  | P080 | 3.729
 |  | P081 | 3.706
 |  | P082 | 3.697
 |  | P083 | 3.677
 |  | P084 | 3.67
 |  | P085 | 3.67
 |  | P086 | 3.652
 |  | P087 | 3.645
 |  | P088 | 3.617
 |  | P089 | 3.61
 |  | P090 | 3.597
 |  | P091 | 3.589
 |  | P092 | 3.588
 |  | P093 | 3.578
 |  | P094 | 3.552
 |  | P095 | 3.54
 |  | P096 | 3.512
 |  | P097 | 3.511
 |  | P098 | 3.508
 |  | P099 | 3.466
 |  | P100 | 3.455
 |  | P101 | 3.429
 |  | P102 | 3.409
 |  | P103 | 3.39
 |  | P104 | 3.38
 |  | P105 | 3.374
 |  | P106 | 3.344
 |  | P107 | 3.336
 |  | P108 | 3.3
 |  | P109 | 3.256
 |  | P110 | 3.25
 |  | P111 | 3.248
 |  | P112 | 3.22
 |  | P113 | 3.212
 |  | P114 | 3.206
 |  | P115 | 3.196
 |  | P116 | 3.176
 |  | P117 | 3.153
 |  | P118 | 3.147
 |  | P119 | 3.131
 |  | P120 | 3.128
 |  | P121 | 3.117
 |  | P122 | 3.047
 |  | P123 | 3.03
 |  | P124 | 3.011
 |  | P125 | 2.981
 |  | P126 | 2.968
 |  | P127 | 2.938
 |  | P128 | 2.935
 |  | P129 | 2.927
 |  | P130 | 2.905
 |  | P131 | 2.888
 |  | P132 | 2.885
 |  | P133 | 2.877
 |  | P134 | 2.877
 |  | P135 | 2.847
 |  | P136 | 2.833
 |  | P137 | 2.829
 |  | P138 | 2.829
 |  | P139 | 2.829
 |  | P140 | 2.829
 |  | P141 | 2.805
 |  | P142 | 2.796
 |  | P143 | 2.78
 |  | P144 | 2.767
 |  | P145 | 2.765
 |  | P146 | 2.75
 |  | P147 | 2.746
 |  | P148 | 2.737
 |  | P149 | 2.728
 |  | P150 | 2.724
 |  | P151 | 2.714
 |  | P152 | 2.708
 |  | P153 | 2.674
 |  | P154 | 2.645
 |  | P155 | 2.627
 |  | P156 | 2.613
 |  | P157 | 2.607
 |  | P158 | 2.571
 |  | P159 | 2.509
 |  | P160 | 2.487
 |  | P161 | 2.477
 |  | P162 | 2.457
 |  | P163 | 2.416
 |  | P164 | 2.413
 |  | P165 | 2.411
 |  | P166 | 2.347
 |  | P167 | 2.346
 |  | P168 | 2.327
 |  | P169 | 2.322
 |  | P170 | 2.304
 |  | P171 | 2.274
 |  | P172 | 2.269
 |  | P173 | 2.252
 |  | P174 | 2.236
 |  | P175 | 2.205
 |  | P176 | 2.19
 |  | P177 | 2.12
 |  | P178 | 2.103
 |  | P179 | 2.102
 |  | P180 | 2.092
 |  | P181 | 2.056
 |  | P182 | 2.051
 |  | P183 | 2.039
 |  | P184 | 2.033
 |  | P185 | 2.029