excel肿么把30个数分成5组每组6个

B2=RAND()向下复制D2=INDEX($A$2:$A$31,RANK(INDEX($B$2:$B$31,MOD(ROW(D1)-1,6)+1+(COLUMN(A2)-1)*6),$B$2:$B$31))向右向下复制到D2:H7区域按F9键可以随机分组