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
Comments
No Comments Exist
Be the first, drop a comment!