Dynamic Dependent Drop-Down Lists in Excel | Expandable & Exclude Blank Cells | Using offset match

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

КОМЕНТАРІ • 46

  • @m.mukhtiarali6063
    @m.mukhtiarali6063 6 місяців тому +1

    a great farmula. i applied and i done this farmula. so great making report. thanks sir

  • @Sk_Sajjan
    @Sk_Sajjan 2 місяці тому

    very nice informative video, Thank You

  • @hpdlive
    @hpdlive 4 роки тому +1

    Sir your knowledge is awesome.

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

    it's very useful. Thanks

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

    Very Nice Video. 👌👌👌

  • @SALEEM0409
    @SALEEM0409 3 роки тому

    Best Explanation !!!!!!!

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

    Very informative

  • @nileshdavane5038
    @nileshdavane5038 3 місяці тому

    In dependent drop list if 1st drop down select then I want that sum

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

    Good work

  • @amrulhoda3509
    @amrulhoda3509 3 роки тому

    Hi sir I can able to copy same formula in below row

  • @DeepakPrajapati-tt7mk
    @DeepakPrajapati-tt7mk 4 роки тому +1

    Sir stock maintain ka format batye with detail

  • @behindthescene2727
    @behindthescene2727 3 роки тому

    bahut acchhhe

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

    Sir want to learn Ms Access completely if you help me.

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 4 роки тому

    It's given the file for excel tutorial, sir. Thanks

  • @khalidalisubhanallah2947
    @khalidalisubhanallah2947 4 роки тому

    Nice video 👍

  • @munishgandhi3564
    @munishgandhi3564 3 роки тому

    very nice

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

    Please share dynamic dependant dropdown list to practice; also make it searchable.

  • @PremSingh-ry7ek
    @PremSingh-ry7ek Рік тому

    How to make height dynamic inside match function sir pls give me some guidance

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

    Thank you sir

  • @ravisen2054
    @ravisen2054 3 роки тому

    sir google sheet per kam nhi kr rha formula

  • @travelwithvinod27
    @travelwithvinod27 3 роки тому

    Nice Video

  • @sandeepgupta6526
    @sandeepgupta6526 3 роки тому

    Thanks

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

    Why sometimes not working this formula, and instead we can use indirect also, do one more video for this

  • @51mrarif
    @51mrarif 4 роки тому

    hello guru ji........... please give me a tips of making family chart in laptop windows 7

  • @pujasingh93
    @pujasingh93 3 роки тому

    Lock kaise kiya aapne plz tell

  • @prashantkshirsagar5673
    @prashantkshirsagar5673 3 роки тому +1

    Sir , Plz provide more than 2 dependent drown list along with deletion of blank cells in the drop down list

  • @sushilaadangale1281
    @sushilaadangale1281 3 роки тому

    Best

  • @tejindersingh7751
    @tejindersingh7751 3 роки тому +1

    Please make a video on auto suggest list as you type. Means just by typing a character the auto suggest list is updated.

  • @rohitkk7744
    @rohitkk7744 3 роки тому

    Sir plz same videos on vba plz sir

  • @chetan1008
    @chetan1008 3 роки тому

    Dependent drop down list with offset

  • @prashantkshirsagar5673
    @prashantkshirsagar5673 3 роки тому

    Sir , ye formula me next row me kaise copy kare

  • @biswajitkaran89
    @biswajitkaran89 3 роки тому

    Sir , I want multi dependent drop down list.

  • @kshitijmittal91
    @kshitijmittal91 4 роки тому

    How to add long paragraphs of text in drop down

  • @TechnicalFarmingAdvisorDrBrajr
    @TechnicalFarmingAdvisorDrBrajr 3 роки тому

    Provide a video on making dependent drop-down list on Google sheet.

  • @NiteshRS
    @NiteshRS 3 роки тому +1

    Sir, thankyou for the video. Mujhe ye problem aa rahi hai ki jab main formula baaki rows mein copy karta hun to wo first row ko hi replicate karta hai jise copy kiya. Agar first row ko change kiya to baaki sab rows mein dependent dropdown same dikhata hai. Har row ke first column ki value change karne se 2nd column ki value change nahi hoti.

  • @ChandanDas-wl2uk
    @ChandanDas-wl2uk 3 роки тому

    🙏🙏💓💓🙏🙏

  • @hardik_parmar_2301
    @hardik_parmar_2301 4 роки тому +1

    Please Share Any Example For More Than 5 Dependent Drop Down List In VBA Form With Code.

  • @syedshahzaibali4729
    @syedshahzaibali4729 3 роки тому

    Sir very nice video, plz tell how we can add more countries after bangladesh.
    Everytime I add everytime change formula. How to do it dynamically ? Sir plz 🙏

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

    Hi bro, bhai plz ek dynamic dependent down list banaeay jis mai countries k names double mai hon, jis tara ap ne countries k names mai Pakistan and UK lika hy, es tara double names mai banaeay plz q k dependent drop down list mai underscore sign use keay baghair name enter nai hota...tnx

  • @rubaalthunayan6319
    @rubaalthunayan6319 4 роки тому

    The counta formula doest not count the cells for each column, it shows 10 which you used in the 4th parameter, I also tried to leave that parameter blank, it showed 1 for all selection :( Please HELP ME I tried all the ways and nothing seems to work. PS: My OS is MAC

  • @rajibsaha6359
    @rajibsaha6359 4 роки тому

    Your drop down list not sorted a-z.

  • @radheybhaiya515
    @radheybhaiya515 7 місяців тому

    Nhi hua