This video is an introduction to the FILTER function of Excel - is this the best Excel function?

Download the file used in the video - [ Ссылка ]
This is the completed version - [ Ссылка ]

Learn over 150 of the best functions in Excel - [ Ссылка ]

The Excel FILTER function is incredibly versatile and powerful. It is a utility function in Excel that can help with many tasks Excel users need to perform.

This Excel formula can be used to lookup and return multiple matches. A common issue with other lookup formulas that the FILTER function solves.

You can also easily lookup with multiple criteria with this function. Excel lookup multiple matches and multiple criteria. And it can do much more. This must be the best Excel function.

00:00 Introduction
00:22 The FILTER function in Excel
05:40 FILTER with multiple criteria
07:50 Return all the results, if no criteria is used with the IF function
09:47 VLOOKUP to return related data for FILTER results
11:29 Edit FILTER to return single columns
13:28 Aggregate the FILTER results

It is a formula equivalent to the filter feature of Excel. It returns a range of results that meet specific criteria.

This range can then be placed on a worksheet or inside another formula. The potential is massive.

This video shows some examples of what it is capable of. But a function is vast really needs further exploration from you.

There will be many more videos to show why this is probably the best function in Excel.

Find more great free tutorials at;
[ Ссылка ]

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]

Connect with us!

LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]

свернуть