最高市值 取出數據 (9599)

F2:F4{=IFERROR(OFFSET(B$1,MATCH(,COUNTIF(F$1:F1,B$2:B$6),)+1,),"")

G2:H3{=INDEX(C:C,RIGHT(MAX(($B$2:$B$7=$F2)*$C$2:$C$7/1%+ROW($2:$7)),2))&""

另解=LOOKUP(1,0/(COUNTIFS($B:$B,$F2,$C:$C,"<"&$C$2:$C$6)>0)/($B$2:$B$6=$F2),C$2:C$6)