Odd result when generating a "Top 5" list..

[TomServo]

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:

Please Login or Register  to view this content.

And my output looks like this:

Please Login or Register  to view this content.

To get the vehicle I use this formula:

Please Login or Register  to view this content.

To get votes:

Please Login or Register  to view this content.

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.

[Pete_UK]

It will probably help more if you attach the workbook - remove anything confidential beforehand.

Pete

[TomServo]

Here it is. Only have testing data in it now.