字符後數字 找區域位置 (13648)

C2{=LOOKUP(1,0/(MMULT(N(LOOKUP(9^9,RIGHT(A2,ROW($1:$9))*1)-IFERROR(MID(SUBSTITUTE(SUBSTITUTE(E$2:E$8,LEFT(A2,MATCH(,0/MID(A2,ROW($1:$9),1),)-1),),"-",REPT(" ",9)),{1,10},9)-{0.1,0},)<=0),{1;1})=1),F$2:F$8)



留言