出现次数最多与最少 取出 (11835)

E3=MODE(C2:C11)

F3{=INDEX(C:C,RIGHT(MIN(COUNTIF(C:C,C2:C11)/1%+ROW(2:11)),2))

一公式 E4:F4{=VLOOKUP(MAX(COUNTIF($C:$C,$C2:$C11)*-1^(B1=$C1)),IF({1,0},COUNTIF($C:$C,$C2:$C11)*-1^(B1=$C1),$C2:$C11),2,)

一公式 E4:F4{=RIGHT(MAX((COUNTIF($C:$C,$C2:$C11)/1%%+(100-ROW($2:$11)*-1^(B1=$C1))/1%+$C2:$C11)*-1^(B1=$C1)),2)*1