Turns out half my old formulas were just dynamic arrays in disguise, written the long way.

Learn the best Excel formulas to enhance your skills in 2025! This tutorial covers underrated Excel functions including ...

Investopedia contributors come from a range of backgrounds, and over 25 years there have been thousands of expert writers and editors who have contributed. Amilcar has 10 years of FinTech, blockchain, ...