When I first discovered Excel's dynamic array functions, my entire approach to spreadsheet design shifted. They replaced my clunky, multistep workarounds with smart, self-expanding formulas that adapt ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work. Most Microsoft Excel functions are autonomous—one ...

Excel's XLOOKUP is great for finding a needle in a haystack, but what if you want all the needles? While XLOOKUP stops at the first match, the FILTER function is built for the dynamic array era, ...

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel’s FILTER() function. There are a number of ways to highlight duplicate values.