Excel Drop Down from Filtered List скачать в хорошем качестве

Excel Drop Down from Filtered List

Get the sample workbook from my Contextures website: https://www.contextures.com/exceldrop... See how to make an Excel drop down list show only the visible items from a filtered list, in this step-by-step video. First, create a named range with employee names. Next, use data validation, to show a drop down list with all the employee names. Then, use a SUBTOTAL formula to number the list of employees. When you filter the list, to hide the rows marked with an X, the numbers show a count for the visible rows only. Create a new list, and use INDEX and MATCH, to find the names from the filtered list, to match each number in the new list. Create a dynamic named range for the new list, and change the drop downs, to use the new name. Video Timeline: 00:00 Intro 00:50 Name the Employee List 01:46 Filter the List 02:24 Number the List 04:37 Create a New List 07:33 Create a Dynamic List 09:38 Change the Drop Down 10:25 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...