Find the Largest Values with Excel 2007's Subtotal Feature
Return to Excel Subtotal Tutorial List.
Excel's Subtotal feature works by inserting the SUBTOTAL function into a database or a list of related data. Using the Subtotal feature makes finding and extracting specific information from a large table of data quick and easy.
Even though it is called the "Subtotal feature", you are not limited to finding the sum or total for selected rows of data. In addition to the total, you can also find the largest values for each subsection of a database.
This step by step tutorial includes an example of how to find the highest sales total for each sales region.
The steps in this tutorial are: