非空排序 數據後面有看不見空格 (15411)

E2:F2下拉{=IFERROR(INDEX($B:$B,RIGHT(LARGE(IF($B$2:$B$99>0,(CLEAN($B$2:$B$99)/1%+ROW($2:$99))*-1^(B$1=$C$1)),ROW(A1)),2)),"")



留言