整列或整行均無相同數字 (10673)


X2{=INDEX($16:$16,SMALL(IF(MMULT(COLUMN(A:O)^0,N(B$2:B$16=C$2:V$16))=0,COLUMN(C:V),99),ROW(A1)))&""


Y2{=INDEX(V:V,SMALL(IF(MMULT(N(B$2:B$16=C$2:V$16),ROW(1:20)^0)=0,ROW($2:$16),99),ROW(A1)))&""


留言