排序 整數往前取數 (9340)


C2:C9{=INDEX(B:B,RIGHT(LARGE(MMULT(LEFT(RIGHT(REPT(0,9)&INT(B$2:B$9),COLUMN(A:I)))*1,10^(9-ROW($1:$9)-1))/1%+ROW($2:$9),ROW(A1)),2))


留言