Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Have a table that totals training points that we are manually sorting by
percentage of total points (difference between points earned and possible points). Looking for a way to have the table auto sort by the percentage when the total points change. The chart is set up as follows: Column B Column C-AG Column AH Column AI Column AJ Names Points are entered Points sumed Possible Points % of Possible Points What I need it to do is when the points summed changes (which changes the %) that the table automatically sorts the table from highest % to lowest % in Column AJ. Any suggestions/ideas are greatly appreciated. dbarrow |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto re-sorting of data- HELP - Is this possible ?? | Excel Discussion (Misc queries) | |||
Auto Generate Sorting table(empty cell)?? | Excel Discussion (Misc queries) | |||
Auto Generate Sorting table?? | Excel Discussion (Misc queries) | |||
Data auto sorting | Excel Worksheet Functions | |||
Auto sorting a table | Charts and Charting in Excel |