Excel’s FILTER function is a masterpiece. It enables you to extract a subset of your data based on the criteria you specify. You can think of it like a lookup that returns multiple matches. It can return a single column of data or multiple columns, in this video I will take you through four different parts which help you understand the filter function completely
Download the workbook here:
https://drive.google.com/file/d/1t84u...
00:00 Introduction
01:09 Part A _ Filter Function Basics
04:41 Part B _ Filter Function Argument Details
05:25 Part C _ Returning A Part Of The Table
06:47 Part D _ Nesting Filter Function With Other Functions
_______________________________________________________
❤Best Free Tool to Grow your YouTube Channel: https://www.tubebuddy.com
_______________________________________________________
advanced excel tricks
excel online course
excel tips and tricks
excel for analysts
microsoft excel tutorials
microsoft excel
excel filter function
filter formula
excel automatic filter based on cell value
excel filter function example
excel filter with multiple criteria
excel return multiple matches
excel vlookup return multiple values vertically
multiple vlookup,excel dynamic arrays
saeed faal
سعید فعال
how to use the filter functin