Dependent Pulldown Menus in Excel
Автокөліктер мен көлік құралдары
This video will show how to create dependent drop-down lists in Microsoft Excel. We will use the INDIRECT function to only show items related to the first option chosen.
You can download the spreadsheet used in this tutorial from the following URL: docs.google.com/spreadsheets/...
Chapters:
00:00 Introduction and Spreadsheet Explanation
00:25 Start of the Formula Explanation
03:40 How to Modify Menu List
04:45 Outro
#dependent #dropdown #list
Пікірлер: 4
This will be nice for formulas dependent on the secondary option.
This will be useful in an excel dashboard
@OfficeMystic
Жыл бұрын
You just gave me a couple ideas. But a little bird told me power bi might be a better route.
@BeaverMonkey
Жыл бұрын
@@OfficeMystic Sounds like a smart and incredibly handsome bird