A1:A16 區域數組公式{=IF(MMULT(N(TRANSPOSE(RIGHT(SMALL(RANDBETWEEN(ROW(1:15)^0,99)/1%+ROW(1:15),ROW(OFFSET(A1,,,C1))),2))-ROW(1:15)=0),ROW(OFFSET(A1,,,C1))),B2:B16,MID(SUBSTITUTE(123456780,B2:B16,),RANDBETWEEN(ROW(1:15)^0,8),1))
D1=SUMPRODUCT(N(A2:A16=B2:B16))
留言
張貼留言