Excel Multiple Dependent Drop Downs скачать в хорошем качестве

Excel Multiple Dependent Drop Downs

Go to http://www.contextures.com/exceldatav... to get the sample workbook with tables and formulas Select an item from an Excel drop down list, and see only the related items in the next drop down list. In this example, there are 4 levels of dependent drop down lists, based on 3 named ranges. Add more lists when you need them, without having to create new named ranges. 00:00 Intro 00:24 Source Lists 01:41 Start the Workbook 04:06 Add More Columns 05:59 Named Ranges 06:31 Named Range 1 08:34 Named Range 2 11:45 Named Range 3 13:03 Drop Down Lists 15:23 Get the Sample File Instructor: Debra Dalgleish, Contextures Inc. Get Debra's weekly Excel tips: http://www.contextures.com/signup01 More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu... #ContexturesExcelTips