How-To Geek on MSN

Forget INDIRECT: The modern way to create cascading drop-down lists in Excel

Use dynamic arrays and tables for fast, scalable cascading drop-down lists in modern Excel.
MUO on MSN

My Excel formulas used to break all the time until I found this function

AGGREGATE was built to handle messy data from the start.