F2:I10{=INDEX(A:A,SMALL(IF(TEXT(ROUND(COUNTIF($B:$B,$B$2:$B$21)/4,),"0;;1")-COUNTIF(OFFSET($B$2,,,ROW($1:$20)),$B$2:$B$21)>=0,ROW($2:$21),99),ROW(A1)))&""
N2:N21=SUMPRODUCT(1/COUNTIF(B$2:B2,B$2:B2))+RAND()
F14:I21{=INDEX(A:A,SMALL(IF(TEXT(ROUND(COUNTIF($B:$B,$B$2:$B$21)/4,),"0;;1")-COUNTIF(OFFSET($B$2,,,ROW($1:$20)),$B$2:$B$21)>=0,RANK($N$2:$N$21,$N:$N,1)+1,99),ROW(A1)))&""
留言
張貼留言