Use Dynamic FILTER Function with Data Validation List to Extract Filtered Data by Computer Geek

#fliter #filterfun #filterfunction #excel #exceltutorial #exceltips
Use Dynamic FILTER Function with Data Validation List to Extract Filtered Data by Computer Geek
How to Filter Data Dynamically with FILTER function from a different worksheet in Excel - Video -1
Link to Video - 2 of Filter function by Computer Geek
   • Filter Multiple Values in EXCEL with ...  
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.

https://www.microsoft.com
https://www.udemy.com
https://www.lynda.com