Episode 632 - Array Function Arguments

Back in podcast 621, I wondered why the function arguments box won’t work with an array formula. It turns out that it works fine… unless you switch applications while the dialog box is shown! In Episode 632, we take a look at why the function did not work, when it does work, and a cool workaround.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!