Hosted on MSN

SUBTOTAL vs. AGGREGATE in Microsoft Excel

For many years, I used the SUBTOTAL function in Microsoft Excel to create easily visible subtotals at the top of my worksheets. However, when I encountered AGGREGATE, this became my go-to function for ...
How-To Geek on MSN

6 silent Excel spreadsheet killers (and how you can stop them)

Audit hidden data, filters, and hard-coded values to ensure your Excel spreadsheets are professional and precise.