Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autosorting to a leaderboard
I want to create a leaderborad in Excel, wich displays the current position
of a contestent. If his score changes (due to data input) his position at the leaderborad changes. How do i do that? I got a list of names and thier value starting at 0 then each round they will get points. I enter the points after each name and the leaderbord auto. shows positions, else i need to sort after each input to have the board up to date |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
autosorting to a leaderboard
Record a macro when you sort your data.
Then do your data entry and rerun this macro. (Tools|macro|macros...) ano wrote: I want to create a leaderborad in Excel, wich displays the current position of a contestent. If his score changes (due to data input) his position at the leaderborad changes. How do i do that? I got a list of names and thier value starting at 0 then each round they will get points. I enter the points after each name and the leaderbord auto. shows positions, else i need to sort after each input to have the board up to date -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a leaderboard in excel? | Charts and Charting in Excel |