How to use FILTER function in Excel; All parameters explained

[@somenmondal2964]

thank you so much for your clips. It is very helpful

[@analyticssuccess]

Thanks a lot for your kind words

[@ChandanS-xy7qe]

Thank you very much. It was very easy to understand.

[@analyticssuccess]

Thanks Chandan

[@iyerravi44]

Simple lucid explanation. You conveyed the point effectively. One suggestion. You could show how Filter is more effective than doing a pivot by demonstrating how we save time. Else this was good, clear and useful.

[@analyticssuccess]

Thank you so much for your feedback. I like your suggestion on the comparison between filter and pivot. I will create a video and share.

[@shuminng8158]

Thanks for sharing such a good function. If we have more than 1 “AND” , do we just key all the AND conditions in the formula?

[@chopraankush]

@@shuminng8158 Yes you are absolutely right. You will follow the same rules, 1) all conditions are in brackets and 2) Use the * symbol for and conditions.

[@analyticssuccess]

Here is the video where I have done the comparison between Filter and Pivot. ruclips.net/video/zxmuFUQLhsc/видео.html