Data Validation List with Dynamic Arrays in Excel - EQ 95
HTML-код
- Опубликовано: 4 сен 2024
- 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
Three hours trying to find the answer. Super thanks!
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!!
This is EXACTLY what I was missing. Thank you!
Cool. Such a short video and yet so helpul. Thank you very much!
Is there a way to get the drop-down arrow to display on the cell even when the cell is not selected?
Great tip.
*THAT'S EXCELLENT!! THANKS!~!~
Thank you. 👍
Good one! Thanks!!
Great Tip!Enjoy Your Vacation "AND RUM" lol ...Thank You Sir :)
Please do a power bi tutorial from beginner to advanced
Spreadsheet king
thnks
sir, how to add function??
sir, how to add function??
I mean how create a function