排序 不同行 (12396)

I6:N8{=INDEX($4:$4,RIGHT(LARGE(N(OFFSET($B5,{1,1,0,0,0,0},{0,1,2,3,4,5}))/1%+COLUMN($B:$G),COLUMN(A1)),2))

可有負數 {=INDEX($4:$4,RIGHT(LARGE((N(OFFSET($B5,{1,1,0,0,0,0},{0,1,2,3,4,5}))&COLUMN($B:$G))*1,COLUMN(A1))))



留言