Get Started 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, sorted A-Z.

Then, see how to create a list of cities and sales reps in a specific region, with both items sorted A-Z

Next, create a filtered list using 2 criteria - region and sales price.

Download the free Excel workbook from my Contextures website:
https://www.contextures.com/excelfilt...

Video Timeline:

00:00 Introduction
00:24 Cities in Selected Region
03:45 Cities and Sales Reps
06:01 FILTER with 2 Criteria
07:53 Get the Workbook

Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips