Data Validation List with Dynamic Arrays in Excel - EQ 95

Excel Quickie Playlist: • Excel Quickies
Excel File: www.teachexcel...
How to make a drop down menu list using data validation and dynamic arrays in Excel 365.
This is a simple procedure, but very easy to forget.
Additional Resources
Dynamic Arrays (msft): support.micros...
Data Validation (msft): support.micros...
Full Tutorial (where this came from): • Ignore Blanks in Data ...
Excel Courses:
- VBA/Macro Course: www.teachexcel...
- Building Professional Forms: www.teachexcel...
- Email Course: www.teachexcel...
TeachExcel.com
#msexcel #excelquickie #tutorial

[@julianaminium1199]

THANK YOU!! I can not thank you enough for this video. I've spent hours trying to figure out an elegant solution for this. So simple and basic. Love It!!

[@personalJoke]

Three hours trying to find the answer. Super thanks!

[@ah-xt2uc]

This is EXACTLY what I was missing. Thank you!

[@ekkiwurm7874]

Cool. Such a short video and yet so helpul. Thank you very much!

[@stopdrinkingleftskoolaid6510]

Great tip.

[@TravisKinley]

Is there a way to get the drop-down arrow to display on the cell even when the cell is not selected?

[@wayneedmondson1065]

Good one! Thanks!!

[@smb52]

*THAT'S EXCELLENT!! THANKS!~!~

[@silent1876]

Thank you. 👍

[@darrylmorgan]

Great Tip!Enjoy Your Vacation "AND RUM" lol ...Thank You Sir :)

[@stans1317]

Spreadsheet king

[@AK-td9zn]

thnks

[@hassan06ny]

Please do a power bi tutorial from beginner to advanced

[@juantoknow]

sir, how to add function??

[@juantoknow]

sir, how to add function??

[@juantoknow]

I mean how create a function