Chapter 14Summarizing Data Using Subtotals or Filter

Adding Automatic Subtotals

Working with the Subtotals

Subtotaling Multiple Fields

Subtotaling Daily Dates by Month

Filtering Records

Using the Advanced Filter Command

Excel in Practice: Using Formulas for Advanced Filter Criteria

Using Remove Duplicates to Find Unique Values

Combining Duplicates and Adding Values

The Subtotal command was added way back in Excel 97. Not enough people realize that the command is in Excel, and those who have tried it often don’t realize how powerful the command truly is. I used to have a regular gig as the Excel guy on Leo Laporte’s Call for Help television show. During one appearance, I showed people how to use the Subtotal command. I figured it was probably ...

Get Microsoft Excel 2019 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial