This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

The SUBTOTAL Function Microsoft Excel's SUBTOTAL function is quite simple to use. It lets you perform subtotal calculations for ranges of cells, and you can decide whether you want to include ...