Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Filtering and subtotalling
|
|
|
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. |
microsoft-excel-courses - Filtering and subtotalling
Resolved · Low Priority · Version Standard
Reply Thu 24 Jan 2008, 14:03Delegate Cavell said...
Cavell has attended:
Excel Advanced course
Filtering and subtotalling
How do you filter a list and then provide subtotal figures for selected criteria and display the subtotals on the sheet?
For upcoming training course dates see: Pricing & availability
RE: Filtering and subtotalling
Hi Cavell
Thank you for your question - this is an interesting one.
Perhaps if you try applying subtotals first, then filtering afterwards, this might provide what you are looking for.
Otherwise you can set up an advanced filter (Data - Filter - Advanced filter) to apply the filter and choose to use the Copy to another location option to separate the filter result from the list/table of data; then apply subtotals to this.
I hope these suggestions help.
Amanda
|