How to Create Multiple Dependent Drop-Down Selections Lists in Excel & Google Spreadsheet
Learn how you can create MULTIPLE dependent data validation lists in Excel on the SAME sheet. In this video I'll show you a solution that requires ONE single formula. This formula also excludes blank cells on the bottom of the data validation list.
In our example the selection of a division will drive the available choices in an Excel data validation list. We'll use the Excel Name function and Indirect formula for the dependent drop down selection.
Additional Excel Functional Playlist: • SmartMinds Excel
Kindly comment below for any specific requirement...or any other query you may have...
Few informative videos —
Create daily task checklist - • Checklist for daily Task. Excel Tips & Tri...
Choose Career Carefully - • How to choose career? अपना करियर सावधानी स...
Know your learning pattern - • How to make your kid Smart and Confident i...
Career Motivation - • Psychometric test motivation
Let’s connect on social:
Facebook - / smartmindsmaps
WebSite - https://smartmindsmap.grwebsite.com/
Follow us on Google : https://www.google.com/search?q=smart...
Like us on Facebook : https://www.facebook.com/profile.php?...
Follow us on LinkedIn : / excelica
Follow us on Twitter : / minds_map
This video answers the following queries:
How to achieve Dependent drop down selection in Excel
How to create Excel drop down list with reference from another cell
Can you select items in an Excel drop down list based on result from another cell?
How do you create data validation using another cell referance?
How do I put multiple items in one cell in Excel?
Data validation drop down list selection without duplicates
How do you do multiple choices in Excel?
Please support this channel:
/ @smartmindsmap9725
Signup for a free webinar session on excel training :
https://docs.google.com/forms/d/e/1FA...
MS Excel tips and tricks
Tags - computer user, learn computer, internet user, excel user, ms office user, excel shortcuts, excel keyboard shortcuts, excel shortcut, excel shortcut keys, learn excel, excel tips, ms excel shortcut keys, microsoft excel, computer, laptop, computer tips & tricks, technology, keyboard, must know, computer basic knowledge, accounting, excel shortcuts in hindi, shortcut keys, excel Excel Shortcuts 2022 | Amazing Excel Shortcuts | Best Excel Shortcuts | Keyboard Shortcuts Computer user must know, keyboard shortcut keys
#SmartMindsMaps #excel #shortcuts