數字位置排序 字母不變 (13255)

G2:J11{=IF(B2=0,"",IF(N(B2),SMALL(TEXT(B$2:B$11,"0;;99;!9!9")*1,SUM(N(ISNUMBER(-G$1:G1)))+1),B2))



留言