最幾高 低混和 提數值 (12753)

F2:H7{=ABS(LARGE(IF(($B$2:$B$21=F$1)*($C$2:$C$21>0),$C$2:$C$21*-1^MOD(ROW(A2),2)),INT(ROW(A2)/2)))

F11:H16{=ABS(LARGE(IF(($B$2:$B$21=F$1)*($C$2:$C$21>0),$C$2:$C$21*-1^(ROW(A1)>3)),MOD(ROW(A1)-1,3)+1))



留言