多领與少领 提出 (10361)

I5 右拉 下拉 {=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(($A$2:$A$26=$H$1)*($D$2:$D$26>0),$E$2:$E$26/1%+ROW($2:$26)),ROW(A1)),2)),"")

N5 右拉 下拉 {=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(($A$2:$A$26=$H$1)*($D$2:$D$26<0),ABS($E$2:$E$26)/1%+ROW($2:$26)),ROW(A1)),2)),"")