By Andrew Gould
Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-filter-function/
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Learn how to use the FILTER function in Microsoft Excel to return filtered lists of values. You'll learn how to apply filters to numbers, dates and text; how to search for values containing text; how to find the biggest, smallest and top N values in a list; how to combine filters using logical operators; and how to use cells to create a convenient way to provide criteria to your filters.
Chapters
00:00 Topic list
00:49 Creating a Simple Filter
05:00 Dealing with No Matches
06:17 Comparing with Aggregate Values
08:06 Returning Top or Bottom Values
11:35 Finding Duplicates and Unique Values
13:22 Comparing Date Values
15:33 Comparing Date Parts
16:46 Basic Text Criteria
18:18 Finding a Word in a String
22:20 Begins and Ends With Conditions
23:40 Combining Conditions with OR
26:11 Multiple Conditions using Different Columns
27:30 Combining Conditions with AND
29:35 Combining AND and OR Conditions
32:19 Using Cell Values as Criteria
34:15 Dealing with Empty Cells
37:21 Adding a Second Set of Criteria
39:17 Adding a Contains Text Condition
41:42 Creating Drop Down Lists
44:37 Adding the Final Conditions
Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!