Domenic wrote...
A couple of issues...

1) It doesn't take into consideration ties for 10th place.

Meaning all tied values should be shown?

2) Owing to the MODE function, #N/A is returned when values occurring
more than once have been exhausted and only values occurring once remain.
....

B1 [array formula]:
=INDEX($A$1:$A$500,MATCH(MAX(COUNTIF($A$1:$A$500,$ A$1:$A$500)),
COUNTIF($A$1:$A$500,$A$1:$A$500),0))

B2 [array formula]:
=INDEX($A$1:$A$500,MATCH(MAX(IF(COUNTIF(B$1:B1,$A$ 1:$A$500)=0,
COUNTIF($A$1:$A$500,$A$1:$A$500))),COUNTIF($A$1:$A $500,
IF(COUNTIF(B$1:B1,$A$1:$A$500)=0,$A$1:$A$500)),0))

without including ties. If ties are an issue, then it's much better to
use two columns of formulas to produce the needed results.