E2:F7{=IFERROR(INDEX($B:$B,RIGHT(LARGE(IF(MATCH($B$2:$B$21,$B:$B,)=ROW($2:$21),ABS(MMULT(($B$2:$B$21=TRANSPOSE($B$2:$B$21))*TRANSPOSE($C$2:$C$21),IF(E$1=$E$1,$C$2:$C$21>0,$C$2:$C$21<0)*1))/1%+ROW($B$2:$B$21)),ROW(A1)),2)),"")
H2:I7{=IF(E2="","",SUM(($B$2:$B$21=E2)*$C$2:$C$21*IF(H$1=$H$1,$C$2:$C$21>0,$C$2:$C$21<0)))
留言
張貼留言