Ashraful has attended:
Excel Advanced course
Organising a worksheet
I am working with a worksheet and have data from several countries in my file. I have put in an autofilter but I want to be able to group each country individually so the overall figures show for that country but have the fucntion whereby when you click it drops down to give a detailed breakdown of the data.
I remember doing something similar on the course bu don't have my manual to hand.
RE: Organising a worksheet
Hi Ashraful
Thank you for your question.
I think by the sounds of what you are wanting to do that you need to use the Subtotals feature in Excel.
Here's how:
1. Select any cell in the column containing the countries.
2. Sort this column so the rows for each country are listed together.
3. Go to Data - Subtotals.
4. In the At each change in box, select the heading for the column you have sorted in (2) above.
5. Leave SUM as the Function
6. Put a tick next to the column/s you want subtotals added into (the column/s you wish to see the overall totals in - these need to contain numeric data).
7. Click OK.
To see different levels of detail, click the 1, 2 or 3 button in the grey outline area on the left side of your screen.
I hope this is what you were after.
Amanda
