不重複 連續區域 (11128)

D2 下拉 {=INDEX(B:B,SMALL(IF(COUNTIF(D$1:D1,B$2:B$16)=INT((ROW(A1)-1)/(COUNTA(B:B)-1)),ROW($2:$16)),RANDBETWEEN(1,COUNTA(B:B)-1-MOD(ROW(A1)-1,COUNTA(B:B)-1))))

格式化 D2:D17=MOD(INT((ROW(A1)-1)/(COUNTA(B:B)-1)),2)