OMG 🔥 ये फार्मूला यूज करो काम होगा सेकण्ड्स में | Dependent Drop-Down Lists in Excel

Поділитися
Вставка
  • Опубліковано 11 січ 2025

КОМЕНТАРІ • 123

  • @harshthakkar8323
    @harshthakkar8323 Рік тому +2

    BHAI BEST OF THE BEST OF THE BEST.....I HAVE SEEN 50 VIDEOS STILL COULDNT DO IT.
    LUCKILY GOT YOUR VIDEO....PROBLEM SOLVED.
    UR THE BEST TEACHER.

  • @deepakadroja6065
    @deepakadroja6065 2 роки тому

    Deepak ji, Abhinandan... Excellent tricks...

  • @sureshsourot8551
    @sureshsourot8551 2 роки тому +1

    bhtrin guru g. ❤️❤️

  • @khuramshehzadofficial9069
    @khuramshehzadofficial9069 2 роки тому +1

    Nice depak bahi

  • @uttamkumar-lr4zu
    @uttamkumar-lr4zu 2 роки тому +1

    Bhai badhiya smjhane walo me se aap Ek ho ... Nice way of teaching..thanks

  • @ManojGupta-nl8fj
    @ManojGupta-nl8fj 2 роки тому

    बहुत ही उपयोगी वीडियो है। बहुत बहुत धन्यवाद्।👌👌👌

  • @virendrahardiya2797
    @virendrahardiya2797 2 роки тому

    भाई आपने बहुत ही बढ़िया टेक्निक सिखाइए आपने

  • @gyanapipasuasmyaham2966
    @gyanapipasuasmyaham2966 2 роки тому +1

    Actually this video is very nice 👍🏻

  • @ronnysaha6587
    @ronnysaha6587 Місяць тому +1

    Thanx bro it helped a lot ✌🏻☺️

  • @gyankeyboardyt
    @gyankeyboardyt 2 роки тому +1

    Nice video
    Thanks you

  • @tauseefalimuhammad631
    @tauseefalimuhammad631 2 роки тому +1

    Amazing and informative video

  • @7513747
    @7513747 2 роки тому +1

    Nice one…👍🏾👍🏾

  • @RamPrakash-in9gp
    @RamPrakash-in9gp 2 роки тому +2

    Great 👍 thanks for your support

  • @dineshkumarsaini7997
    @dineshkumarsaini7997 2 роки тому +1

    Very knowledgeable sir

  • @rajubhutki3724
    @rajubhutki3724 2 роки тому +2

    Nice Informative Video❤ 🤗

  • @masroorahmed3462
    @masroorahmed3462 2 роки тому +1

    sir yaar coreldraw ka b video banao na plz aapka tareeqa parhaany ka bohat zabardast hai sir

  • @srikanthgali8991
    @srikanthgali8991 9 місяців тому +2

    Your style is different. Voice good❤❤❤

  • @umairahmed1851
    @umairahmed1851 Рік тому

    Zabardast 👍

  • @rameshchandragoyal4494
    @rameshchandragoyal4494 2 роки тому

    Very nice & informative

  • @nurulhaque89
    @nurulhaque89 2 роки тому +1

    Nice video Sir

  • @sazzadkabirrokon8368
    @sazzadkabirrokon8368 2 роки тому +1

    I am from Bangladesh.
    I love your all videos.
    Best wishes for u.

  • @BijuMuttaseril
    @BijuMuttaseril 2 роки тому

    Very good tutorial...
    Thanks from Kerala.

  • @ShivamKatheriya-yz6wf
    @ShivamKatheriya-yz6wf 2 роки тому +1

    Very good video

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 2 роки тому

    Sir very clear explanation

  • @yogeshmathur3201
    @yogeshmathur3201 Рік тому

    Very informative in simple way !!

  • @ParminderKaur-kd1lb
    @ParminderKaur-kd1lb 2 роки тому

    Thanks a lot sir. You are superb.

  • @sanjayparihar641
    @sanjayparihar641 2 роки тому +2

    You always Rocking sir Ji 🙏🏻☺️

  • @Jamalhappy
    @Jamalhappy Рік тому +1

    Zabardast

  • @mashokhan8811
    @mashokhan8811 2 роки тому +1

    Excellent

  • @precioussimplemessagesofli3092
    @precioussimplemessagesofli3092 2 роки тому +1

    Greetings from Indonesia! Even having a language barrier, the presented steps are clear and easy to be followed. Good Work!!

  • @Infohongo
    @Infohongo 2 роки тому +1

    Bhai continue this series

  • @VikramSinghKhalsa1998
    @VikramSinghKhalsa1998 2 роки тому

    Excellent Sir

  • @rheapeter9709
    @rheapeter9709 Рік тому +1

    Thank you sir

  • @dilipinamdarpatil6301
    @dilipinamdarpatil6301 2 роки тому +1

    Nice 👍

  • @Thecrackersacademy1
    @Thecrackersacademy1 5 місяців тому

    well explained..

  • @Kumar-he7ey
    @Kumar-he7ey Рік тому +1

    SIR ,,IF I TOLD YOU 100** THANK YOU THAN ITS LESS ON FRONT OF YOUR HELP SIR THANKX A LOT🤗🤗🤗🤗🤗🤗🤗🤗🤗🤗🤗🤗🤗🤗🤗🤗🤗🤗

  • @sonalmehta259
    @sonalmehta259 2 роки тому +2

    Deepak sir it is a humble request to publish a video based on appointment slots made in ms excel. You have always been a very good teacher to make us learn Excel for all of us. Every time coming up with new tutorials. An honour to have such an amazing teacher. Thank you.

    • @gaganwadhwafreelancer
      @gaganwadhwafreelancer 2 роки тому

      What are your requirement.
      Please explain may be i can HELP you.

    • @sonalmehta259
      @sonalmehta259 2 роки тому

      @@gaganwadhwafreelancer Actually I am going to start a receptionist work in a clinic and I have make a list of patients by booking their appointments in ms excel make use of different formulas. Could it be possible for you to help me figure out my problem. If you could tell me which formula to be used while preparing appointments schedule for patients on a daily basis. Thank you.

    • @GauravKumar-hc3xr
      @GauravKumar-hc3xr 2 роки тому

      @@gaganwadhwafreelancer mujhe ek stock mention ka solution chahiye kya aap meri madat kar sakte hai

    • @gaganwadhwafreelancer
      @gaganwadhwafreelancer 2 роки тому

      Sir Please See this Video
      May be Help you
      Related to schedule tracker
      ua-cam.com/video/3Wo95mKUrA0/v-deo.html
      If Not Than tell me
      Overview of your data i will try to help you.

    • @gaganwadhwafreelancer
      @gaganwadhwafreelancer 2 роки тому

      @@GauravKumar-hc3xr ji sir

  • @sayalisakpal3668
    @sayalisakpal3668 5 місяців тому +1

    Superbbbbb

  • @ShivamComputerInstitute
    @ShivamComputerInstitute 2 роки тому +1

    Good tricks

  • @ihgamingfun6295
    @ihgamingfun6295 2 роки тому

    Thanks 🙏🙏

  • @MegaAvimanyu
    @MegaAvimanyu 2 роки тому

    superb

  • @KavitaFadnavis
    @KavitaFadnavis Рік тому

    Very nice.

  • @kapilpandey5970
    @kapilpandey5970 2 роки тому +1

    Sir aap tally prime bhi sikho please...

  • @RekhaKumari-de9xo
    @RekhaKumari-de9xo Рік тому

    Very good sir

  • @vijayi2887
    @vijayi2887 8 місяців тому

    Kindly make a video of pricelist drop down in variation

  • @gajendrasingh9486
    @gajendrasingh9486 Рік тому +1

    If state showing in column instead off row...kindly guide...thank u for this video

  • @masroorahmed3462
    @masroorahmed3462 2 роки тому +1

    thanks

  • @mukeshsingh3614
    @mukeshsingh3614 2 роки тому +1

    Sir plz advanced Excel me full course wala video Dale please sir

  • @pcexcel1m740
    @pcexcel1m740 2 роки тому

    Nice sir

  • @awaisgaming7984
    @awaisgaming7984 2 роки тому

    Bhai jaan Stock exchange ka profit and loss and dividend etc is ki calculation per video banaye maine sari videos dekhi mujay stock exchange ka related koi video na mili

  • @SamanSisira-e9r
    @SamanSisira-e9r 4 місяці тому

    Best

  • @syedikramullah1114
    @syedikramullah1114 2 роки тому

    Nice

  • @PoonamChauhan-dp1oi
    @PoonamChauhan-dp1oi Рік тому

    Khatrnak

  • @avinashagivale5485
    @avinashagivale5485 2 роки тому +1

    Thank you sir.
    Please make same dependent drop-down list level 3 in google sheets..

  • @manojparmar4155
    @manojparmar4155 2 роки тому

    usefull

  • @AkhileshStudioB
    @AkhileshStudioB 2 роки тому

    सर हिंदी में डिपेंडेंट ड्रॉप डाउन लिस्ट एक वीडियो बना दीजिए आपकी अति कृपा होगी सर

  • @nadirjavaid4741
    @nadirjavaid4741 2 роки тому +1

    Sir I am work in Izhar group of company

  • @trickysportsbesttricks7383
    @trickysportsbesttricks7383 Рік тому +1

    Sir, I want to make multiple searchable dropdown list. Please guide me or publish a video for multiple searchable dropdown list.

  • @adityaverma2720
    @adityaverma2720 2 роки тому +1

    Please aap indirect function par ek video bana sakte hain??

    • @gaganwadhwafreelancer
      @gaganwadhwafreelancer 2 роки тому

      You Can See this Video
      THAT MAY BE HELP YOU
      INDIRECT FORMULA
      ua-cam.com/video/7q84aIHsBhY/v-deo.html

  • @Rutvikpatil12345
    @Rutvikpatil12345 2 роки тому +1

    👌🌹🙏

  • @N_H12345
    @N_H12345 Рік тому

    ❤️All

  • @ch.mohdimtiyazrukmuddin
    @ch.mohdimtiyazrukmuddin 2 роки тому

    Sir please Stone crusher machine Excel fully automatic accounting video

  • @rajeshbunkar3044
    @rajeshbunkar3044 Рік тому +1

    Sir hindi font ki drop down list kaise banaye

  • @srikanthgali8991
    @srikanthgali8991 9 місяців тому +1

    Visual basic programs post

  • @mashokhan8811
    @mashokhan8811 2 роки тому +1

    sir can you please upload on dashboard for finance

  • @sahraj78
    @sahraj78 2 роки тому

    Sir pl, please suggest which Antivirus is best for Laptops

  • @falgun1980
    @falgun1980 2 роки тому

    Hi
    Mr dipak
    आप के वीडियो देखे
    बहोत अछे है
    आप से एक प्रश्न हे कि दो नंबर की गिनती सही आए उसके लिए क्या फार्मूला हे
    जिसकी
    1 - 10 = 9
    लेकिन ये पूरे 10 नंबर हे
    लेकिन एक्सेल मे =sum(10-1)=9
    Solution क्या हे

  • @1947IndianLover
    @1947IndianLover Рік тому

    " - " underscore isko formula se hataya ja sakta ha ek video mein dekhe tha Satish ji ki video ma

  • @MaghanYadvase
    @MaghanYadvase 2 місяці тому +1

    Hi

  • @archanakannojiya6995
    @archanakannojiya6995 2 роки тому +1

    Sir meri word ki file h Puri complete ho gayi thi
    Usme ek problem aa gaya h page number ek sequence me nahi h agar solution h to plz bataye

  • @Daljitsingh-to5qy
    @Daljitsingh-to5qy 2 роки тому

    Sir I want complete tabs of Excel full video like you have made for ms word . No video is comparable to your

  • @prabhatmishra1002
    @prabhatmishra1002 Рік тому

    Ye same list Google sheet pe kaise bnaye jb large date ho to😊

  • @Merehanumanji2000
    @Merehanumanji2000 2 роки тому +1

    Hello sir
    Excel me iteam name ke saath me
    Pics. , Ltr. , Qty. And bag ki list automatically kaise mis me aaye

  • @ziyadahsan1637
    @ziyadahsan1637 2 роки тому +1

    I want help from you in excel please reply

  • @vinayakpopti1356
    @vinayakpopti1356 2 роки тому

    Hello Deepak Ji, looking for pivot table masterclass dynamic Dash boards, Plz do the video on this

  • @AloksCollection
    @AloksCollection 6 місяців тому +1

    Sir how to get GP name from village column what is the formula

  • @kirangupta6780
    @kirangupta6780 2 роки тому +1

    Sir ji excel ke video ka link de do

  • @sonalmehta259
    @sonalmehta259 2 роки тому +2

    Deepak sir actually I am going to start my job as a receptionist in a clinic. So it would be great if you could help me out. I have to make a list of patients according to their appointment slots in ms Excel by making use of different formulas. So if you could assign me some help such as how to prepare appointment list in Ms Excel, which formula to be used and how to create a proper Excel sheet like a professionalist. So is it possible for you figure out and let me know the solution of it. Thank you.

  • @Arun_Peswani
    @Arun_Peswani 2 роки тому +1

    Thanks for another great video once again...
    I have a query here; as you have shown dependent list basis table headers, what if the state names are in column A, city names are in column B, and village names are in column C? It becomes difficult then to make a dependent drop-down list in excel. Can you please help with any solution to this? There are many videos on youtube for this purpose, but the methods are very long and not simple like yours.
    Here is a data sample....
    States Cities Villages
    Rajasthan Jaipur Village-RJ1
    Rajasthan Jaipur Village-RJ2
    Rajasthan Alwar Village-RA1
    Rajasthan Alwar Village-RA2
    Haryana Ambala Village-HA1
    Haryana Ambala Village-HA2
    Haryana Rohtak Village-HR1
    Haryana Rohtak Village-HR2

    • @Arun_Peswani
      @Arun_Peswani 2 роки тому

      Thank you for liking this question Deepak Ji 😊
      Agar aapke paas iska solution ho to pls help share kijiyega 🙏

  • @arunimapal4779
    @arunimapal4779 2 роки тому +1

    Can I make the main list in one worksheet and the indirect list in another, so that no one can see the main database?

    • @sebghatulbarykhabaey6680
      @sebghatulbarykhabaey6680 2 роки тому +1

      Yes, You hide worksheet from VBA editor and change the property of the worksheet to Xlsheetvery hidden and protect the structure window.

  • @lingu1982
    @lingu1982 4 місяці тому

    Bro i need how to make index match to whole sheet
    Pls share the tool

  • @satyenshukla3823
    @satyenshukla3823 9 місяців тому +1

    How can searchable option can be added in this

  • @manojkanzariya5283
    @manojkanzariya5283 9 місяців тому

    Bhai koi material stock inventory ka video he to batao.
    Me dish company ka kaam karta hu. To muje kya chahiye vo batata hu, muje company ka material mere stock me aata he or muje koi bhi installer ko vo materials issue krna hota he,. Or vo materials vo installer installation me use krta he par jo use nahi hua vo materials ka stock janana he.

  • @bhusanhontal9291
    @bhusanhontal9291 Рік тому +1

    SAME NAME RANGE PROBLEM BECAUSE DISTRICT NAME,BLOCK NAME,PANCHAYAT NAME AND VILLAGE IS SAME NAME "KORAPUT" OF STATE ODISHA ,KORAPUT DISTRICT SO HOW TO CREATE DEPENDENT DROP DOWN LIST IN EXCEL. PLEASE UPLOAD THIS RELATED VIDEOS.

  • @techknowledgegyan5439
    @techknowledgegyan5439 2 роки тому

    Sir agar kisi table ke header mein "-" ya koi special character rakhna ho toh kya karen? Jab bhi kar raha hu tab under score "_" a ja raha hai result mein. Koi solution hain?

  • @sohelislam6375
    @sohelislam6375 2 роки тому

    Dear Sir.
    How to km distance calculation in excel by Google map.

  • @knowledgecosting8235
    @knowledgecosting8235 Рік тому +1

    Such Dependent Drop-Down Lists not working in Google Sheet, please tell us what to do?

  • @akshaynaik701
    @akshaynaik701 2 роки тому +1

    How can we generate list under mother components for assembly

  • @UtkarshShukla-y2g
    @UtkarshShukla-y2g 10 місяців тому +1

    यह तो एक लुकअप से भी हो जाता और वीरू कब से भी हो जाता

    • @kanpuriya_pk
      @kanpuriya_pk 5 місяців тому

      You pls Use V lookup (Legends using this formula)✔️

  • @vikramghuge5628
    @vikramghuge5628 2 роки тому

    SUM 0 aa raha hai to use blank kaise kare

  • @AkhileshStudioB
    @AkhileshStudioB 2 роки тому

    डिपेंडेंट वर्ड को डिलीट करते हैं तो ड्रॉप डाउन लिस्ट में क्यों डिलीट हो जाते हैं सर

  • @rakeshsarma4264
    @rakeshsarma4264 3 місяці тому +1

    Excel nhi aata hain to kyun aaya UA-cam pe

  • @amirhaiderbarcha
    @amirhaiderbarcha 9 місяців тому

    Error aaraha ha😢

  • @umashankarbareth9317
    @umashankarbareth9317 10 місяців тому

    I have tried it but it shows an error " The source currently evaluates to an error do you want to continue??"

    • @PritamDas-wl7yy
      @PritamDas-wl7yy 10 місяців тому

      same problem!
      did you find any solution?

  • @RK-zg6mj
    @RK-zg6mj 2 роки тому +1

    .

  • @pawanofficialmail1688
    @pawanofficialmail1688 Рік тому

    Thankyou so much Sir

  • @masroorahmed3462
    @masroorahmed3462 2 роки тому +1

  • @mkraj6312
    @mkraj6312 2 роки тому

    प्लीज सर आपके नंबर सेन्ड कर दो

  • @arifaliarifali26
    @arifaliarifali26 Рік тому +1

    Very nice Information Thanks A lot

  • @mhu516
    @mhu516 Місяць тому +1

    Very good