最高最低 緊接分別提取 (14507)

G2{=ABS(MAX(IF(B$2:B$16=F2,C$2:C$16*-1^MOD(ROW(A2),2))))

K2:L5{=ABS(MAX(IF($B$2:$B$16=$J2,$C$2:$C$16*-1^(K$1=$L$1))))