In the video below, I show how to get started with the Excel FILTER function, which is available in Office 365.
You can enter a formula in one cell, and the results spill down onto the worksheet, to show all the results. And unlike other filters in Excel, the FILTER result list will update automatically, if you change the criteria.
Continue reading “How to Get Started With Excel FILTER Function”