I have a table of fantasy football numbers that I add to each week. Then to the right of that, I have a summary sorted by who is winning. Is there a way to have excel automatically sort the "leaders" list each time I add something to the table? Hope that made sense.[/u]
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Automatic Sort
- Thread starter packfan
- Start date
Ok, now I'm confused. I'm so used to bat17 giving the obvious/best answer that I'm stumped why it hasn't been mentioned before.
If you are editing existing table entries (not adding records) you can just create a query based on the table and throw a descending sort into it. That would give you an 'at a glance' leaders list.
Something I was thinking about though is, you probably do not want it to automatically sort anything until you're done entering all the data. With a fantasy football league, I'd guess you were entering a separate record for each player and what their actual stats were...or, a total for a player each week thus giving one record per player per week.
If your base table has values that do not require further calculation, a crosstab query might be the way to go to get a one row summary per player AND have it sorted in descending order by the overall score.
A good way to do this could still be via a dataentry form with a button on it that you click when you are all done.
Mike
If you are editing existing table entries (not adding records) you can just create a query based on the table and throw a descending sort into it. That would give you an 'at a glance' leaders list.
Something I was thinking about though is, you probably do not want it to automatically sort anything until you're done entering all the data. With a fantasy football league, I'd guess you were entering a separate record for each player and what their actual stats were...or, a total for a player each week thus giving one record per player per week.
If your base table has values that do not require further calculation, a crosstab query might be the way to go to get a one row summary per player AND have it sorted in descending order by the overall score.
A good way to do this could still be via a dataentry form with a button on it that you click when you are all done.
Mike
Upvote
0
Similar threads
