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 ...

W hen writing formulas in Excel, SUM and VLOOKUP are staples for beginners. But since Excel has over 400 functions, it's helpful to know more of the extremely useful ones, especially when looking to ...