Advanced drop down lists with dynamic array formulas UNIQUE & FILTER (Excel 365 beginners tutorial)
This video looks at two dynamic arrays functions - UNIQUE and FILTER and shows you how you can use them to create a more advanced drop down list. This easy beginners tutorial will help bring your spreadsheet knowledge up to the next level.
The file is available to download from my Google Drive if you want to follow along or use it for reference in your own time.
Download the file here: https://drive.google.com/file/d/1yNjf...
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
Check out our playlist on inputting, viewing and managing data: • FREE Excel course for beginners: Week...
Or check out the following videos:
Drop down lists: • Excel Basics: EXCEL DROP DOWN LIST - ...
UNIQUE function: • Video
XLOOKUP: • What is XLOOKUP and why is it a good ...
Named ranges: • Naming data in excel and how to use i...
Using named ranges and XLOOKUP together: • XLOOKUP & Named Ranges: use them toge...
