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. Thanks

 

[buxtongt]

Welcome to MrExcel.

How would you calculate the ranks? Something like wins-loses? Do you have a particular way you want to handle ties?

 

[dfd0001]

Thanks!

I would like to sort it in wins and loses. As far as ties go maybe alphabetically by name if the records are the same. I can send you my spreadsheet so far if that will help. I have tried to google things about sorting and ranking but cannot seem to get anything to work and I havent used macros in quite some time.

 

[GopherUK]

 

[dfd0001]

Thanks. I like that way that is done. Now is it possible to tranpose that and maybe have the rows move so that the name at the top would be the leader.

Im trying to post a picture of the way I have it laid out right now but I am unable to.

 

[GopherUK]

Print screen>paste into MS Paint>Save as jpeg>upload to tinypic.com

 

[dfd0001]

Here is the layout that I have. I have more participants but this is a rough picture of the way it is laid out.

 

[GopherUK]

 

[buxtongt]

You could even do this without the helper D column, just work its formula into the rank formula. Or you could just hide it (make sure you copy it down far enough first though).