C2{=INDEX(B:B,RIGHT(SMALL(MMULT(MID(SUBSTITUTE(B$2:B$9,"M",REPT(" ",29)),{1,2}*29-28,29)*10^{9,2},{1;1})+ROW($2:$9),ROW(A1)),2))
G2{=INDEX(B:B,RIGHT(SMALL(MMULT(MID(REPLACE(F$2:F$9,MMULT(ISERR(-MID(F$2:F$9,COLUMN(A:Z),1))*(MID(F$2:F$9,COLUMN(A:Z),1)<>""),ROW($1:$26)),1,REPT(" ",29)),{1,2}*29-28,29)*10^{9,2},{1;1})*1+ROW($2:$9),ROW(A1)),2))
留言
張貼留言