AGGREGATE was built to handle messy data from the start.

If you need to calculate dates in your spreadsheets, Excel uses its own unique system, which it calls Serial Numbers. Every date (month, day, year) and time (hour, minute, and second) has an ...

Power users love to talk about how powerful and awesome Excel is, what with its Pivot Tables, nested formulas, and Boolean logic. But many of us barely know how to find the Autosum feature, let alone ...