Get Specific Data with Excel FILTER Function

Get Specific Data with Excel FILTER Function In Excel for Office 365, you can use the FILTER function to create dynamic lists, based on your criteria. These lists will update automatically, if you change the source data or the criteria. In this video, see how to use the new FILTER function to create a list of cities in a specific region. Next, remove duplicates with the UNIQUE function, and finally, the use SORT function to put items in alphabetical order. Download the free Excel workbook from my Contextures website: www.contextures.com/excelspillformulaexamples.html Video Timeline: 00:00 Excel FILTER Function 00:19 Sales Data 00:33 Start FILTER Formula 00:59 FILTER Arguments 02:01 UNIQUE List 02:30 SORT the List 02:42 Spill Range 02:57 Get the Workbook Instructor: Debra Dalgleish, Contextures Inc. More Excel Tips and Tutorials: www.contextures.com/tiptech.html Subscribe to Contextures YouTube: youtube.com/user/contextures?sub_confirmation=1 #ContexturesExcelTips

• #education
• #get_specific_data_with_excel_filter_function
• #excel_function
• #excel_filter_function
• #excel_unique_function
• #excel_sort_function
• #excel_filter
• #excel_filter_formula
• #excel_spill_function
• #excel_dynamic_array
• #microsoft_excel
• #excel
• #excel_tips
• #excel_video_tutorial
• #excel_tutorial
• #debra_dalgleish
• #contextures
• #contextures_inc