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

Investopedia contributors come from a range of backgrounds, and over 25 years there have been thousands of expert writers and editors who have contributed. Samantha (Sam) Silberstein, CFP®, CSLP®, EA, ...

Replace legacy formulas with MAP, BYROW, BYCOL, SCAN, and REDUCE to build secure, scalable, and automated spreadsheets.

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. David Kindness is a Certified Public Accountant ...