非空數字排序 顯行號 (14326)

D2{=IFERROR(RIGHT(SMALL(IF(B$2:B$16<>"",(B$2:B$16/1%%&TEXT(ROW($2:$16),"00"))*1),ROW(A1)),4)*1,"")

另解{=IFERROR(MOD(SMALL(IF(B$2:B$16<>"",B$2:B$16/1%%+ROW($2:$16)),ROW(A1)),100),"")



留言