Index Match formula Vs Dget formula in excel | Full define Index Match and Dget in excel hindi (CC)

Поділитися
Вставка
  • Опубліковано 9 кві 2020
  • You learn in this video how to work Index match and Dget in reverse look and also solve duplicate name problem with this formula.
    #indexmatch #dgetinexcel #advancedexcel #computergyanguruji
    www.amazon.in/shop/computergyanguruji
    Follow us on
    instagram
    / computergyanguruji
    Twitter
    / c_g_guruji
    Facebook
    / computer-gyan-guruji-1...
    MS Excel Videos
    • Hindi English Dictiona...
    MS Word
    • MS Word
    MS PowerPoint
    • MS Power Point
    MS Paint
    • MS Paint
    MSW Logo
    • MSWLogo
    Notepad & HTML
    • Notepad complete tutor...
    Computer Education
    • Education
    Other
    • Other video
    Tally
    • Tally ERP.9 Rules of D...
    Internet
    • internet
    Computer GK
    • GK
    Reasoning
    • Reasoning
    Airthmatics
    • Airthmetic

КОМЕНТАРІ • 43

  • @inayakidvlog9741
    @inayakidvlog9741 4 роки тому +2

    I am very happy to know about DGET function and you explained about duplicate name issue very easily,, thank sir

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

    Your video penetrates to the mind leaving no doubt left. Thanks

  • @Ashishkumar-ik7db
    @Ashishkumar-ik7db 4 роки тому +1

    Excellent sir this video very important in maximum data work,🙏🙏🙏

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

    Sir bahot बढ़िया manipulation किया

  • @sudhirkumar-il1ef
    @sudhirkumar-il1ef 3 роки тому

    Gajab hai sir thank u

  • @RAJKUMARYadav-97
    @RAJKUMARYadav-97 3 роки тому

    VERY NICE EXPLAIN

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

    Very nice explain

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

    Very nice sir ji. A lot of stuff is available to learn. Thanks!!

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

    Mesmerized Sir

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

    excellent from nepal sir 🇳🇵🙏🇳🇵

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

    You explain very well

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

    Thank you . understood

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

    Nice Video Sir, Very helpful!

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

    Sir me aapke sare video dekhta hun aur mujhe samajhnme bahut aasani hota hai. Kya aap mere comments k reply main vlookup k sare videos serially jo aapne upload kiye hai muje reply karenge. Mujhe suru se samajh ne me aasaini hoga.
    Thank you sir and upload this type of educational video. Thanks a lot sir

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

    Excelant explanation.
    Thank You ji.

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

      Its works if we are searching single id,
      But its not working in full student pay fees list.
      "Automated Fees Status and fees receipt Software in Excel in hindi"

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

    Excellent

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

    So nice update hai

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

    Totally awesome lecture ☺️

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

    Well explained

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

    You are great sir,

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

    Thank you sir

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

    Dropdown list without duplicates in excel if already available in table.By clicking data from dropdown list may show all duplicate data available in the table.

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

    Thanks sir 🙏👍

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

    🙏🙏🙏🙏🙏

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

    Dear sir please ek full tutorial video Hlookup and Vlookup pr multiple examples ke saath video banao

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

      hlookup or vlookup par pahle hi kafi video hain aap hamri excel play list me search karen

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

    Dear sir please ek full tutorial video Dash board Excel pr

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

    I want index match formula applied for two different ecxel sheets date value where source will be program name and episide number together.

  • @kalapalababurao1788
    @kalapalababurao1788 Місяць тому

    Good
    How To get Rahul (2 rows) data at a time

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

    Hlo sir excel ki koi start se video send kro

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

    Dear Sir, pls help, jai se sumif se value ka sum ho ta hain aur link rahta hain vaise hi character ka kar saku pl help

  • @BalvirSingh-qs9kz
    @BalvirSingh-qs9kz 4 роки тому

    Sir, Rahul name ke sabhi ek sath how aar.

  • @Its.my.pleasure
    @Its.my.pleasure 3 роки тому

    Dget to xlookup ka alternative nikala

  • @advocate.lalitsharma.4805
    @advocate.lalitsharma.4805 4 роки тому +1

    sir very very good video sir aap se nivedan hain ki video ke saath traning file bhi download karne ki suvidha pradan kare mob 9826537455

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

    Can we get dynamic list with d get formula

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

    Hi

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

    Chota sa tabel me sida ankho se hi pata chalta hai, itna bada formula jarurt nhi aur bada tabel me aap log explain karoge nhi, faltu ka timepass hai

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

      ok bro, waise hamne ye bataya hai ki konsa formual kahan par ya kaise kaam karta hain, uske liye jyada bada data lene ki jarurat nahi hoti.