排列 三條件依序 (13487)

H2:J16{=INDEX(A:A,RIGHT(SMALL(MATCH($A$2:$A$16,$E:$E,)*10^8+MATCH($B$2:$B$16,$F:$F,)*10^7+$C$2:$C$16/1%+ROW($2:$16),ROW(A1)),2))



留言