I have a football pool worksheet.
My goal is to have a button that displays a message box with the players in order of how many points they have.
So far I have been able to display this message box with one problem...
The problem occurs when there is a tie between two players. If they have they same score it will only display the first score in the row.
In my attachments when you press the macro button "score" it displays a message box saying:
"Sue is in first place with 12 points.
Bob is in second place with 9 points.
Bob is in third place with 9 points.
Larry is in forth place with 3 points."
I want it to say:
"Sue is in first place with 12 points.
Bob and Dave are tied for second with 9 points.
Larry is in (third or forth, doesn't matter) place with 3 points."
Even if it needs to say
"Bob is in second place with 9 points.
Dave is in third place with 9 points."
would be an improvement.
Here is my code so far and i've attached the file.
Thank you.
Bookmarks