I am developing on a workbook for managing car shows. and the main feature is a popular vote count. 98% of the time I have the formulas working well and giving me a Top 5 list for winners. But if I put in enough votes for entrant #2.. I get a 52 for an entrant entry in the next row.
I have gone through the formulas several times.. they are correct and should give me the next winner in line. Just when #2 comes within range of the top 5.
Here is how the source table looks:
And my output looks like this:
To get the vehicle I use this formula:
To get votes:
It works as long at vehicle 2 doesn't get into the top 5.. I am not sure if other numbers can do the same or not. Perhaps I am over thinking the formulas and I missed doing it an easier way.. not sure. I built this from examples I have found while searching the web.
Bookmarks