How to Make a Dynamic Data Validation Drop-Down List in Excel
Are you fed up with having to continually add new data to your data validation drop-down lists? Are you also fed up with having to modify the source data to extend the list manually each time new data has been entered?
In this blog, Edmund, one of our Office experts, will show you how to make dynamic data validation drop-down lists and extend the lists automatically when new data is entered.
How to Use the Excel Dynamic Array FILTER Function
What do you do if you want to Lookup multiple criteria that returns all match results, not just the first match? Then the new Excel Dynamic Array FILTER formula will come to the rescue. It will take you to the future!
This function is only available to Office 365 subscribers.
