Am using Excel to count ballots for a car show. I have a series of numbers in each of several categories.

Mode tells me which car got the most votes for first place in each category.

Once I find the number that occurs most often using mode formula, is there a formula to find the number that occurs second most often. Only thing I can do right now is delete the number that occurs most often from the series until I see the mode change in each category. Only then can I identify the one that occurs second most often to award a second place trophy.

Current mode formula also does not let me know when there is a tie. It goes automatically to the first "mode" in the series.

There's got to be a simpler way.
Thanks