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.
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
