Here's an introductory example on how to use the awesome =FITLER function in Excel to return an array of multiple values based on 1 or more criteria. FILTER is really powerful and can be used in combination with other functions to make it really dynamic in your workflows. I'll be posting lots more intermediate-advanced examples of FILTER soon! #Excel #analyst #data #exceltips 💻 | Excelwithkyle23

Google Sheets FILTER function: what it is and how to use it

Basic filter example

Excel FILTER Function: Beginner to Pro - Excel Campus

FILTER Function

Reference Map vs. Thematic Map: 18 Map Types to Explore

.forEach(), .map(), .filter() .... What's the difference?

forEach() vs. map() - What’s the Difference?