多合併格 找最大與最小 (14120)

C10:F15{==INDEX(PERCENTILE(IF((LOOKUP("嫻",$A$10:$A10)=$A$3:$A$4)*($B10=$B$2:$S$2)*(LOOKUP(COLUMN($B:$S),COLUMN($B:$S)/($B$1:$S$1<>""),$B$1:$S$1)=LOOKUP("嫻",$C$8:C$8)),$B$3:$S$4),{0,1}),MOD(COLUMN(A1)-1,2)+1)