Excel Dynamic Array Functions Video#6: FILTER function easy Explained, 4 concepts in 5 examples
Hello and welcome to a new video discussing the new dynamic array functions, video #6
In this video we are going to look at the filter function we are going to see 4 features and 5 examples
1) how filter function can retrieve single or multiple columns
2) how we can filter tables using single or multiple criteria
3) Filtration using “and” logic versus “or” logic
4) how you can instruct filter function what to do if the value not found
& finally how filter function works perfectly with excel tables
To download the excel:
https://drive.google.com/file/d/1e-jh...
To watch the full playlist
• Dynamic Array Functions
To subscribe to the channel:
/ @aaaexcel
To follow on Facebook:
/ excelispower
To follow on LinkedIn:
/ amratef