G7 右拉 下拉 {=IFERROR(SMALL(IF(1-ISERR(FIND($C7,$G$3:$P$5)*FIND($D7,$G$3:$P$5)*FIND($E7,$G$3:$P$5)),$G$3:$P$5),COLUMN(A1)),"")
另解 {=IFERROR(SMALL(IF(MMULT(N(LEN(SUBSTITUTE(SMALL($G$3:$P$5,ROW($1:$30)),$C7:$E7,))=3),{1;1;1})>2,SMALL($G$3:$P$5,ROW($1:$30))),COLUMN(A1)),"")
另解 {=IFERROR(SMALL(IF(LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($G$3:$P$5,$C7,),$D7,),$E7,))=4-SUM(1/COUNTIF($C7:$E7,$C7:$E7)),$G$3:$P$5),COLUMN(A1)),"")
另解 {=IFERROR(SMALL(IF(MMULT(1-ISERR(FIND($C7:$E7,SMALL($G$3:$P$5,ROW($1:$30)))),{1;1;1})>2,SMALL($G$3:$P$5,ROW($1:$30))),COLUMN(A1)),"")
留言
張貼留言