Hi,
I would like to build a database that ranks players monthly as well as yearly. It can be interactive too, as in the user can specify if the data should be sorted monthly/yearly. The constraints are:-
1. The order of the players may not be the same always so basically I need excel to search for a particular player and then assign his score to his name.
2.There might be some new players every month and some players going out every month.

Constraint number 1 is the most important and I have not been able to find a way around it..
Any suggestions/advice??
Thanks!