三號碼相同 無論次序 (9594)


G2:H6 {=INDEX(A:A,SMALL(IF(MMULT(RIGHT(SMALL(MID($A$1:$A$35,{1,2,3},1)+ROW($1:$35)/1%,ROW($1:$35)*3-3+{1,2,3}))*1,10^{2;1;0})=SUM(SMALL(MID($E$2,{1,2,3},1)*1,{1,2,3})*10^{2,1,0}),ROW($1:$35),99),ROW(A1)))&""


留言