Excel dilettantes and seasoned Microsoft Office professionals alike may be surprised to learn that in Excel one can make a drop down list based upon a second drop down list (or, similarly, data validation list that is based on a second validation list).
See how to create a Drop Down List that is based on another drop down list using there
features:
1)Data Validation List
2)Defined Names
3)Create Names From Selection
4)INDIRECT function
5)SUBSTITUTE function
While you're stuck at home, make the most of your time by learning a new language, skill, or even train for a remote-work job with our new premium online courses.
Be the First to Comment
Share Your Thoughts