C2:C13 {=INDEX(B:B,IF(MOD(ROW(A1),2),SMALL(IF((COUNTIF(C$1:C1,B$2:B$14)=0)*MOD(ROW($1:$13),2),ROW($2:$14)),RANDBETWEEN(1,6-INT(ROW(A1)/2))),MATCH(C1,B:B,)+1))
E2 {=COUNT(0/((COUNTIF(B:B,C2:C13)=1)*IF(MOD(ROW(3:13),2),MATCH(C3:C13,B:B,)-MATCH(C2:C12,B:B,),1)=1))
留言
張貼留言