Ranked Choice Voting for Multiple Positions

I need an Excel Ranked Choice Voting Calculator.

I found a thread from 2012 with a spreadsheet that works to show who came in first.

However, I also need to see who came in second, and maybe even third.

We usually have two positions that need to be filled. Sometimes it may be three.

Attached is the file I borrowed from the previous thread. (Thank you to User shg who did the work on that file!)

On the Working spreadsheet, can I just delete the values from the winners (Allen) column, and when it recalculates, would that be the 2nd Place?

Each time the winner must have 50% plus 1.

Ballots must contain numbers for all candidates. They cannot leave a number off for any candidate.

Is there a way to set this up so that you can automatically see who was first, second, third?

Thank for your help.

Originally Posted by DefiantDJ

... On the Working spreadsheet, can I just delete the values from the winners (Allen) column, and when it recalculates, would that be the 2nd Place? ...

Wouldn't you just have to look at the elimination table (columns J to N) at the point where there are 3 people left (i.e. column K in your example sheet) ? Allen, Dave and Ethan would thus be 1st to 3rd, in that order.

Hope this helps.

Pete

I am using Excel Office 365.

There will be more like 8 to 10 candidates.

The example didn't include that many.