Automatic Leaderboard

[dfd0001]

Hey I am trying to create a leaderboard for a football pool that I have put together. The spreadsheet calculates each person's wins and loses each type the winner is inputted into the sheet. I would like to create a leaderboard that will update and rank everyone from 1 to 41 participants. My participants start in A3-A43, with another column for wins and another for loses. How can I get this to sort each time a game winner is inputted. I have attached the spreadsheet that I am currently trying to create. I would like to have the participant's move up and down the leaderboard depending on their win/lose record. Thanks

[micope21]

Hi
Done. Have a look the file. 1 SettingLeaderboard sheet and other Leaderboard sheet. This is done on Win with=RANK(c4,$c$4:$c$44) Mean(=High score start 1 to 41) If you want other column for lost You need put in =Rank(d4,$d$4:$d$44,1) mean (=Lower Score start 1 to 41) Look how I done the file. Do the same if you want put in another for Lost.

Enjoy

Cheers

[Palmetto]

Cross posted at Ozgrid

[dfd0001]

Sorry about the cross post.

micope21 thanks. Works perfectly. That was just what I had spent hours trying to figure out, but were unable to get it to work just right.