How to Filter Data Dynamically with FILTER function from a different worksheet in Excel - Video -1

How to Filter Data Dynamically with FILTER function from a different worksheet in Excel - Video -1
Linke to Video - 2 of Filter function by Computer Geek
The Excel FILTER function "filters" a range of data based on a given criteria. The result is an array of matching values the source range. When this array is the final result (i.e. the results are not feed into another function) matching results will spill over on to the worksheet. Simply put, the FILTER function allows you to easily extract matching records from a larger set of source of original data based on criteria you entered.

The results from FILTER are dynamic. When values in the source data change, or the source data array is resized, the results from FILTER will update automatically.

[tamimahmad]

It's getting easier and easier with excel with these new dynamic array function.
first those Xlookup and now this filter function

[ashishnehra]

great from micrsoft to have made our life that much easier wtih thses functions.

[hanobhattia]

EXCEL अब इन कार्यों के साथ एक डेटाबेस है

[nikhilsk]

Thank you so much this was extremely helpful and a saviour!🙂

[alissaghom]

microsoft is leasing the new functions to make it easier easier and easier. great vid geek

[najwanbilgarami]

This is so easy so brilliat and so greatly illustrated. very nice geak

[lakhwabindari]

This function in combination with xlookup can make your excel as database. supeb sir

[tahirraza]

So simple yet so powerful this function is

[raheelbhatti]

really really great sir but not found on my version excel 2016. what should i do?

[chachargreen]

Woowww very nice and informative video