Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sorting
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Sorting
Resolved · High Priority · Version 2003
Reply Wed 19 Jan 2011, 14:31Delegate Ras said...
Ras has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Sorting
Hi my question is relating to sorting data in Excel 2003.
I have a table which shows various complaint catagories on the left hand side and monthly volumes in each column, I want to show the latest column from the highest volumed complaint volume at the top and then I want the previous columns to show the volumes for this catagory in previous months. Any idea on how i could do this please?
Ras
For upcoming training course dates see: Pricing & availability
RE: Sorting
Hi Ras, thanks for your query. I think your first port of call would be to set up some custom views so you can sort and hide the relevant material and then snap to the dynamically updated information everytime you need it by selecting your custom view. If you want a more sophisticated structural change to occur in the arrangement of fields in the table you could either use the spreadsheet as the basis for a database query or write some code to complete re-order the sheet according to your criteria.
Hope this helps,
Anthony
Mon 31 Jan 2011: Automatically marked as resolved.
|