排列 依優先順序 (14413)

H4:K12{=OFFSET($F$1,RIGHT(LARGE(($D$4:$D$12="对")*10^8+(100-CODE($G$4:$G$12))*10^6+$F$4:$F$12/1%%+$C$4:$C$12/1%+ROW($3:$11),ROW(A1)),2),1-COLUMN(A1))