fbpx

Filter() is one of the new dynamic array functions in Excel. So what does that mean? If you have used Excel you will know that generally it has made like a single celled organism – create your formula in ONE cell and then copy it down or across. The new range of dynamic array formulas return a WHOLE BUNCH of answers i.e. an array. So in this blog post I am going to explore just ONE of them – the Filter() function.

You can view the video here

Here are some links to some other tutorials if you want to do a deeper dive

Mynda Treacy explains how to use the Filter() function
Check out this indepth tutorial from ablebits.com