編號AA 取出 (13431)

C2:F8{=TEXT(SMALL(TEXT(TEXT(LEFT(TEXT(MID($B2&"A",ROW($1:$59),COLUMN($A:$Z)),),COLUMN($A:$Z)-1),"0;;;!0")*ISERR(-MID($B2,ROW($1:$59)-1,2)),"0;;"&10^9)*1,COLUMN(A1)),"[<"&10^9&"]AA0;")



留言