Video: I don't use filters in Excel anymore. I use this other function instead
Van: Chandoo - Chandoo
Duur: 16:17
Deze video gaat volledig over de Filter()-functie. Van eenvoudig tot uitgebreid wordt behandeld.
Excel is has 100s of functions, but my absolute favourite has to be the FILTER function. It let's you filter a dataset based on conditions. This makes the job of data analysis and calculating summaries so much easier. You can create any type of complex criteria with FILTER function to simplify your job. In this video 💡⏱👉 ================ 0:00 - Introduction to FILTER function with simple examples 1:41 - Understanding the spill range & FILTER output 2:46 - Printing just the names, not all data 4:07 - Count of FILTER results (using # operator) 5:02 - AND condition with FILTER 7:30 - OR condition, filtering data that meets any condition 9:42 - NOT condition with Excel FILTER function 11:53 - Implementing a complex business situation with FILTER 14:48 - What if there is an ERROR? 15:28 - Next steps
Functies: FILTER(), AANTALARG(), EN(), OF()
