B2:E16{=IFERROR(SMALL(ROW(INDIRECT(-LOOKUP(1,-LEFT(B$2,{1,2,3}))+(COUNTIF(B$2,"*=X*")=0)&":"&-LOOKUP(1,-RIGHT(B$2,{1,2,3}))-(COUNTIF(B$2,"*X<=*")=0))),ROW(A1)),"")
另解{=IFERROR(SMALL(ROW(INDIRECT(-LOOKUP(1,-LEFT(B$2,FIND({"<X","<=X"},B$2)-1)-{1,0})&":"&-LOOKUP(1,-MID(B$2,FIND({"X<","X<="},B$2)+{2,3},9)+{1,0}))),ROW(A1)),"")
留言
張貼留言