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