Why You Should Use Filter Formula in excel - Every Excel User should Know

Поделиться
HTML-код
  • Опубликовано: 9 сен 2020
  • Why You Should Use Filter Formula in excel - Every Excel User should Know - learn Microsoft Excel New Filter Formula in Hindi Which is much batter than Advanced Filter Function in excel. excel filter function is new and still available in Office 365 insider which returns multiple match results. #office365 #filterformula #exceltutorial
    Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day...
    Deepak EduWorld Playlist's:
    ADVANCED EXCEL ► goo.gl/A6LdZA
    ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
    Excel Tips & Tricks ► goo.gl/wAj1jh
    MS WORD ► goo.gl/B4TeSA
    HTML5 & CSS3 ► goo.gl/2PFgs8
    COMPUTER TECHNICAL videos ► goo.gl/paZmpn
    Automatic Invoice's in excel ► goo.gl/dFhg54
    Subscribe Deepak EduWorld ► / deepakeduworld
    Instagram ► / deepakeduworld
    Facebook page ► / deepakeduworld
    LinkedIn ► / deepakeduworld
    Facebook Group ► / deepakeduworld
    Thanks For Watching #deepakeduworld

Комментарии • 295

  • @nayanasworld9965
    @nayanasworld9965 2 года назад +4

    Sir, it's most useful formula indeed.Aapka bohot - bohot dhanyavad🙏🙏🙏🙏🙏

  • @gorakhanathk5054
    @gorakhanathk5054 3 года назад

    What a better formula. Nicely explained. Thank you Sir. BAHUT KAAM KI CHEEJ HAI.

  • @simplified6840
    @simplified6840 3 года назад +5

    Very Helpful Video. Easy to understand & includes a lot of useful information.

  • @rupbetkar8241
    @rupbetkar8241 3 года назад +1

    मे आपको 2 साल से फॉलो कर रहा हुं.. आपका सिखणेका तरिका kaafi lajawab hai

  • @rohitshaw8487
    @rohitshaw8487 3 месяца назад +2

    It is very helpful video, thanks for it.

  • @Ravi-yd7gg
    @Ravi-yd7gg 3 года назад +1

    Thanks..a lot great video...now I'm using this lovely formula

  • @YNP777
    @YNP777 3 года назад +1

    Excellent formulas as well your teaching method 👍🏻😍

  • @yogeshchauhan7594
    @yogeshchauhan7594 9 месяцев назад +2

    Thankyou sir ❤

  • @shantilalrajput8708
    @shantilalrajput8708 2 года назад +4

    Thank you sir V.Useful sir 🇮🇳🇮🇳🇮🇳

  • @vishalmoyal7297
    @vishalmoyal7297 3 года назад +4

    I knew the use of filter.
    But for two criteria, that's what I was looking for.

  • @vipulagarwal5155
    @vipulagarwal5155 Год назад

    Thank You for this educational tour. It was very useful. Please make more videos like these.

  • @hareshpatel4474
    @hareshpatel4474 3 года назад

    Aapka jawab nahi, babut achha formula hai.

  • @I_A_S_2
    @I_A_S_2 Год назад +1

    Thank you sir ji 🙏🙏🙏

  • @ramsevakjhariya9215
    @ramsevakjhariya9215 2 года назад +1

    Thanks sir ji

  • @deepamanmappy
    @deepamanmappy 3 года назад

    I tried it before but now I get it how to to use it properly thanks a lot 😊

  • @hi2every1
    @hi2every1 3 года назад

    Brilliant technique

  • @abdulnasirafridi
    @abdulnasirafridi Год назад +1

    excellent sir.... weldone you really works hard and to best of your skills

  • @chinmayakumardas6489
    @chinmayakumardas6489 3 года назад

    Very well informative... Thanx

  • @sadinbangla747
    @sadinbangla747 2 года назад +1

    Thanks Brother for teaching.

  • @manojmakwana8461
    @manojmakwana8461 3 года назад +8

    sir i am using excel 2010 how to implament this? i dont see filter formula in this version... hope you will reply early as possiblr

  • @atulshukal4072
    @atulshukal4072 3 года назад +1

    Very good Sir

  • @chyarmennanda
    @chyarmennanda 3 года назад +1

    Sir G, akdam bobaal ki trick h

  • @binaykumarnayak9114
    @binaykumarnayak9114 3 года назад +1

    So Nice Trick... Thank you

  • @Altaf_Alam
    @Altaf_Alam 2 года назад +1

    Thank u sir ....😍😃

  • @ameerhamzaansari5295
    @ameerhamzaansari5295 3 года назад +1

    aap ka sikhany ka anaz bohat acha ha

  • @AnimalsCasa
    @AnimalsCasa 9 месяцев назад +1

    ❤ awesome Guru ji

  • @vikashmourya8964
    @vikashmourya8964 3 года назад +1

    Maja aa gaya sir......ap Kamal ho

  • @ghumansaab2314
    @ghumansaab2314 3 года назад

    Very helpful topic, 👍👍👍

  • @HungryFossilsOfficial
    @HungryFossilsOfficial 3 года назад +1

    Fir ekbar Dil jit liya...

  • @mohammedaveshpathan5341
    @mohammedaveshpathan5341 2 года назад +1

    You are great Deepak sir
    Excellent
    Superb

  • @TechoBurner
    @TechoBurner 7 месяцев назад +1

    Helpful Video Thanks ❤❤❤

  • @vasantkumarkantilal2973
    @vasantkumarkantilal2973 3 года назад

    Bahut mehnat karte ho sir.very good.

  • @MustjabsEditing
    @MustjabsEditing 8 месяцев назад +1

    Great

  • @cartoonloversop6019
    @cartoonloversop6019 2 года назад

    सर इस विडियों के लिए आपका बहुत बहुत धन्यवाद
    इस फार्मूले का उपयोग करके अब ओफिस मे मेरे पास कम से कम एक घंटे का समय बच जाता है

  • @MuhammadIbrahim-jf4ix
    @MuhammadIbrahim-jf4ix 3 года назад +1

    Ms excel k guru ho ap.

  • @RajendraSingh-ce8pi
    @RajendraSingh-ce8pi 3 года назад +2

    Dhansu. Formula bro

  • @aryashsonkar9204
    @aryashsonkar9204 3 года назад +1

    Thank u sir 🙏🏻

  • @vimalsoni185
    @vimalsoni185 3 года назад +1

    Wow sir very amazing formula in excel
    Thanks 😃😃😃
    Please provide practice sheet

  • @nikhilkukde6704
    @nikhilkukde6704 3 года назад +2

    Great work

  • @mohammadyousufhingoro3770
    @mohammadyousufhingoro3770 3 года назад +1

    zabardast dear thanks

  • @TheAmit306
    @TheAmit306 Год назад +1

    Thank you 🙂

  • @AnilKumar-gj5xj
    @AnilKumar-gj5xj 3 года назад +1

    Excellent sir 👍👌

  • @mohanpal2737
    @mohanpal2737 3 года назад +1

    awesome trick sir

  • @_prachi
    @_prachi 3 месяца назад

    Life saving✨

  • @pianostudio232
    @pianostudio232 3 года назад +5

    You are the best teacher of excel forever so much clear concepts
    Good job lots of best wishes for your further videos 👍👍👍❤️❤️

  • @susheelshakya465
    @susheelshakya465 3 года назад +1

    Nice vedio sirji

  • @harkeshsharma3264
    @harkeshsharma3264 3 года назад +1

    Great, thanks

  • @veterinarydundera4699
    @veterinarydundera4699 3 года назад +1

    Great sir
    Thanks a lot

  • @dilipsuman2085
    @dilipsuman2085 2 года назад

    Very useful function 🔥

  • @prabhatverma4243
    @prabhatverma4243 3 года назад

    Thanks a lot ....

  • @usamahansari6795
    @usamahansari6795 3 года назад

    Thanku so much Bhai ♥️

  • @sandeepbhati8838
    @sandeepbhati8838 3 года назад +1

    Awesome

  • @differentkuber
    @differentkuber 3 года назад +1

    Excellent video 👍

  • @nafeeskhan7657
    @nafeeskhan7657 8 месяцев назад

    Thank you

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 3 года назад

    Great sir

  • @dipankarbhattacharjee9112
    @dipankarbhattacharjee9112 3 года назад

    Very helpful

  • @apeduworld7004
    @apeduworld7004 3 года назад +2

    Amazing knowledge

  • @VirendraKumarbillo
    @VirendraKumarbillo 3 года назад +1

    Thanks sir

  • @kumaruttam2535
    @kumaruttam2535 4 месяца назад

    thanks sir same Advance filter use

  • @taizoondean689
    @taizoondean689 2 года назад

    Thanks bhai 🙏

  • @javedahmed8343
    @javedahmed8343 2 года назад

    Splendid

  • @farrukhazad
    @farrukhazad 3 года назад +1

    good work i like

  • @rohitgaura9778
    @rohitgaura9778 3 года назад +1

    Good information sir 🙏🙏🙏🙏🙏

  • @shailendrasingh9838
    @shailendrasingh9838 4 месяца назад

    Awesome ❤

  • @balmishra007
    @balmishra007 3 года назад

    You are great sir

  • @rooneychauhan7718
    @rooneychauhan7718 3 года назад +1

    Sir it's very useful formula, sir please start Google docs, sheets full tutorial i'm very curious to learn new things waiting for your new videos related to Google sheets full explanations

  • @thehannu7302
    @thehannu7302 3 года назад +1

    Helpful sir👍

  • @Soham542
    @Soham542 2 года назад

    Thank you sir🌹🌹🌹🌹

  • @successmaharjan2906
    @successmaharjan2906 Год назад

    Thank u sir

  • @maheshsanghani6380
    @maheshsanghani6380 3 года назад

    good to learn .

  • @rajeshdewangan8605
    @rajeshdewangan8605 3 года назад +1

    Excellent👍👍 sir

  • @rapsayush3990
    @rapsayush3990 3 года назад

    Legend ho aap

  • @rohitgaura9778
    @rohitgaura9778 3 года назад +1

    Great post video sir very very useful trick sir ❤️❤️🙄🙄

  • @srinivasakula7831
    @srinivasakula7831 3 года назад

    very useful formula

  • @AdnanKhan-fc3uc
    @AdnanKhan-fc3uc 6 месяцев назад

    Very helpful.
    We need one more requirements items hardisk and East West North need in same row or one cell

  • @parimalgoradiya8538
    @parimalgoradiya8538 3 года назад

    Very nice SIR JI 👍

  • @vijaysahal4556
    @vijaysahal4556 3 года назад +1

    nice 👍👍👍👍👍

  • @Parimal_Asodiya
    @Parimal_Asodiya 2 года назад +1

    Good

  • @BaljinderSingh-he8ys
    @BaljinderSingh-he8ys 3 года назад

    very nice...

  • @BABA20111
    @BABA20111 Год назад

    Good..

  • @AsgharAli-ck8qh
    @AsgharAli-ck8qh Год назад

    Nice video!
    I have a problem with my excel data base sheet when I use the filter in my sheet, it shows some rows hidden like the row at the end of entries showing the results, total and other calculations pls, can you help me to solve this issue?

  • @gullahmad1309
    @gullahmad1309 3 года назад

    Good Work sir

  • @jaipalsingh1416
    @jaipalsingh1416 2 года назад

    how to get option of selecting all range in drop down list ( like i have some 10 Year sale data i want to get year-wise and then buyer-wise data from drop down but i also need one more option to select all the buyer during that year in filter function )

  • @naughtyvibs1
    @naughtyvibs1 10 месяцев назад +1

    Aap nhi jaante bhaiya ki aap kitne saare logo ki help kar rahe hain in videos ke through

  • @technicaldo3423
    @technicaldo3423 3 года назад +1

    Nc idea

  • @umeshchandarana8415
    @umeshchandarana8415 2 года назад +1

    Best

  • @AmitPal-ek9mw
    @AmitPal-ek9mw 3 года назад

    Very nice sir

  • @fhussainmomin268
    @fhussainmomin268 2 года назад +1

    Great sir...
    Sir..filter formula me array me sirf selection colums hi chahiye..je se k..A D F H to kya kare...please help

  • @sandeepsharma1645
    @sandeepsharma1645 3 года назад +1

    very nice

    • @DeepakEduWorld
      @DeepakEduWorld  3 года назад

      This tutorial will help you 👍 watch it deepakeduworld.com/convert-number-into-words/

  • @razaktv3654
    @razaktv3654 3 года назад +1

    good

  • @pknewknowledge6629
    @pknewknowledge6629 3 года назад +1

    Sir kya kisi specific things ya data ko jan ne ke liye use hota hai

  • @rupeshkumarrawat3688
    @rupeshkumarrawat3688 Год назад +1

    Tell me one thing
    In example number 1 how you define range in Regine cell(like East west etc)

  • @sadiqulalam8863
    @sadiqulalam8863 8 месяцев назад +2

    sir how to sumif filtered amount?

  • @virendrahardiya2797
    @virendrahardiya2797 2 года назад +1

    भाई आप तो मास्टर के भी मास्टर हो, आपको सेल्यूट करता हूं

  • @bharduwajom
    @bharduwajom 3 года назад +1

    Deepak ji mujhe ek hospital ki inventory model with pic ke banani hai after summary taiyar karni hai help kare kisi formule se

  • @anshulbharti683
    @anshulbharti683 3 года назад

    Gazab

  • @rahulnegi5426
    @rahulnegi5426 3 года назад

    Sir how to use this formula when there is an N/A in the array or range?

  • @SmartTechmehul
    @SmartTechmehul 3 года назад +6

    Hello sir,
    Me office 2019 use karta hu but filter formula available nahi he to kese apply karu.
    Please help

  • @sahiltallyvideo
    @sahiltallyvideo 3 года назад +1

    #sahiltallyvideo
    Aapke video useful h sir ji

  • @khiladichunky3673
    @khiladichunky3673 Год назад +1

    Very helpful video👌👌great work Deepak sir❤️👍🙂
    Sir 2 question h jisme confusion h
    Q1. Sir ek sheet pr data ho to array select ho jaaega 2 ya 2se jyada mein ho to filter formula kaise use karenge?
    Q2. Sir between dates ka data nikalna ho single sheet ho ya jyada tb kaise nikalnge kyu ki sir jb nikalte h dates ka TB usme sabhi members ka AA jata h for example Ram shyam mohan Ankit mujhe Ram ka nikalna h 1/1/23 to 15/1/23 ka to kaise nikalna h plzz sir btayega🙏🙏
    Sir plzz reply jarur krna😊