Excel’s new group of functions will break your brain in a good way

I didn’t think much of LAMBDA helper functions when Microsoft added them to Excel. However, after finally trying them out, they proved to be a revelation. They work with LAMBDA functions, allowing you to apply custom functions to rows, columns, and even entire arrays without writing multiple formulas or complex VBA. While there are seven LAMBDA helper functions in Excel, I will focus on the four I use the most—BYCOL, BYROW, SCAN, and REDUCE.