I have a simple Excel worksheet comprising between 10 and 12,000 rows. I want to be able to summarise the data with subtotals to 3 levels:
1. At Customer level
2. At Account number level (within Customer)
3. At Product Code level (within Account no)
I'd like to be able to group the rows and show subtotals for each of these 3 levels such as using the Outlines feature in Excel. However, I do not want to go through all 12,000 rows grouping by Customer or by Account No. It would take forever. Is there a quick method of achieving this in Excel ?
Thanks for your help