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
On this page of the site you can watch the video online Excel Dynamic Array Functions Video#6: FILTER function easy Explained, 4 concepts in 5 examples with a duration of hours minute second in good quality, which was uploaded by the user AAA Excel's Power 28 September 2020, share the link with friends and acquaintances, this video has already been watched 662 times on youtube and it was liked by 33 viewers. Enjoy your viewing!
