I Want to make automated leaderboard, when i enter data its chance beetween rank like :
David - 7
Jeff - 10
Sylvain - 3
Paul - 1
Carl - 6
want it appears like
Rank 1 - Jeff - 10
Rank 2 - David - 7
Rank 3 - Carl - 6
Rank 4 - Sylvain - 3
Rank 5 - Paul - 1
if i had a new score like 3 poitns for Carl... want it go automatically
Rank 1 - Jeff - 10
Rank 2 - Carl - 9
Rank 3 - David - 7
Rank 4 - Sylvain - 3
Rank 5 - Paul - 1
The best approach depends - if you have direct entry of the values, you could have an event macro that sorts the table every time you change a value.
Or if you use formulas to extract the values (based on another table), you could use formulas to sort the values too, except you need to address possible ties and how to break them.
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks