In EXCEL, 16 people participated in 18 activities. Each group requires 6 members, and each person is required to participate in the same number of times. What should I do?

It is suggested in advance that if you must use the formula, you need to set the number of iterations to 50 first.

Enter "serial number range" in D2, 16 (i.e. total headcount) in E2, set to "recalculation and liquidation" in H2, "auxiliary column" in B5 and "serial number" in B6.

Select C5: H5 cell range, and then enter "= if ($ I $2 =" recalculate ",if (sum ($ C $4: $ H $4)).

Select the C4: H4 cell range, enter "=if($I$2=" empty", "",countif($C$5:$H$5, C5)), and then press Ctrl+enter.

Six people were randomly selected through H2. Of course, you can also insert a row of names in six rows, and directly combine the names through the index and match functions.