B2:G9{=IFERROR(-LOOKUP(9,-MID($A2,SMALL(IF(ISERR(-MID(SUBSTITUTE($A2,".",0),ROW($1:$98),1))*ISNUMBER(-MID(SUBSTITUTE($A2,".",0),ROW($2:$99),1)),ROW($2:$99)),COLUMN(A1)),ROW($1:$9))),"")
另解{=IFERROR(-LOOKUP(,-MID($A2,SMALL(IF(MMULT(N(ISNUMBER(-MID(SUBSTITUTE($A2,".",0),ROW($1:$50)+{0,1},1))),{2;1})=1,ROW($1:$50)+1),COLUMN(A$1)),ROW($1:$5))),"")
留言
張貼留言