Sir ji aap apna motivation hamesh rakhana kyoo ki mere jasie layman bahut hai idar jisko aap jaise guru zaroorath hai .. As usual informative video. thanks
Sir im banker And get every solution from your video Please make video advanced bank reconciliation with multiple bank ledger I,m very keen to see your video and teaching style with good concept clear
Me likhne wala tha ki ye vlookup ki tarah large data ka result nhi la sakta or aapne bata hi diya last me ki nhi la sakta. Vlookup toh vlookup hi he😜 धन्यवाद ye formula sikhane k liye
Really appreciate your effort , But Vlookup and Dget has little difference Dget only works as search such as use only one row , but vlookup works on multiple row i-e if you want to fetch data from multiple row to another multiple row than vlookup is best
Hello Sir Main Aap ke Video se Aap se Bahut Kuch sikha hu me Aap ke Chanel pr ghanto bitata hu mujhe bhahut kuch milta hai sikhne ko.......Us k Liye Bhahut Bhahut Dil se thank's Dhanywad Aap ka. Lekin Sir Ek Problem Aa Rahi hai jo aap ne (DGET) Function bataya ha bahut achcha hai lekin me is ko practical kar rha hu to kuch data to sahi aa rha hai lekin Kuch first ki 5 Entry me value #N/A Aa Rha Hai... Sir Esa Kyu...? baki row num. ka data sahi aa rha hai....🤔😊
Sir ji I know how to process vlookup /Xlooup and index match and now learned Dget. So how these functions are different from the the advanced filter. Ap ke paas aise koi video hai jise compare kar sake
Sir ye video only playlist me visible ho rha hai aur apke upload section me bhi nhi show ho rha aisa kyu.... Kuch time tak to private tha abhi ko basic Playlist me visible hua hai.... Aur iska notification bhi nhi aaya hai....
I thought who knows VLOOKUP, that person is awesome in excel. par aaj pata chala ki vlookup to INDEX MATCH, NAMING RANGE, DGET, SUMPRODUCT ka bachcha hai..............😜🤣
If you want to use iffuce 365 you may use Web version..You may able thanks practice all latest formula of oddice 365 You may find office 2016 or 2019 download link are the in no. RUclips channel.Downloas and start your practice now
Sir ji aap apna motivation hamesh rakhana kyoo ki mere jasie layman bahut hai idar jisko aap jaise guru zaroorath hai .. As usual informative video. thanks
Sir the way you explain in a calm and confident way. i am a big fan of your teaching technique. keep it up sir, you are doing great ♥️
Thanks Piyush..God bless you..Keep learning and keep exploring
Sir im banker
And get every solution from your video
Please make video advanced bank reconciliation with multiple bank ledger
I,m very keen to see your video and teaching style with good concept clear
Guru ji,
Ye to mere Liye Naya function hain
Thank you guru ji
Ok dear..👍
First time sir mene aapke channel pr visit kiya or mujhe kafi advance learn krne ko mila.... thankyou very much ✌️🙏❤️
Thanks dear..happy learning..God bless you❤️
D Functions is Able to help in very hard problems. Most usefull concepts I happy new Learning .
Thank you Sir!!
Thanks Shiv for learning on regular basis.Keep Learning and enhance your skills.
this is such a great Fn , kabhi use nhi kia tha maine , now its so handy to use...! Respect
👍😊
Bahot baria andaz hay bhai...... Allah khush rakhay apko
Thanks dear.Happy learning ❤️
Simplified एंड ट्रांसपरेंट टीचिंग सर❤
Your teaching method is superb sir💐
Thanks
Me likhne wala tha ki ye vlookup ki tarah large data ka result nhi la sakta or aapne bata hi diya last me ki nhi la sakta. Vlookup toh vlookup hi he😜 धन्यवाद ye formula sikhane k liye
Thanks Bhati Ji.. Happy learning
Thanks sir, wonderful video. Aap bhut Achha samjhate ho. Again thanks
Thanks Mohit Ji👍🙏Have a great day ahead.Practice jaroor kiya kijiye regular
Sir All your videos worth watching and thumbs up. Sir you have very mesmerizing voice. Thank you for sharing you excel skills.
Thanks Sandeep for appreciation ,Hope you like the concept I am trying bro deliver in different way🙏❤️😊
सर , यु टयूब पर Excel के काफी विडियो देखे हे पर उसमे वह चीज नही मिलती जो आप के विडियो मे मिलती हे और वह हे आपकी Smile सर आप यु ही विडियो बनाते रहे
Thanks dear itne pyare aur valuable appreciation ke liye..God bless you dear
I like your teaching approach, thank you so much.
Thanks dear..Happy Learning ❤️
A great approach to describing a function helps to grasp it. thanks
Thanks dear
great ...thank u sir,,, one quesion kya vlookup chod de use karna ya uska koi alag mahtv hai
Thanku sir for new concept this really helpful function and new replacement of vlookup good night sir.
Thanks dear❤️😊🙏Good Night
Ek number sir 👌👌👌👌
Really appreciate your effort , But Vlookup and Dget has little difference Dget only works as search such as use only one row , but vlookup works on multiple row i-e if you want to fetch data from multiple row to another multiple row than vlookup is best
super say bhi upar vlookup say best h formula h 👌🏻👌🏻
Thanks Karan🙏😊❤️
बहुत बढ़िया है 👍
❤️😊🙏
Thanks you sir for explaining dget function and their drawback.
Thanks Hemant,Hope you like the concept of DGET their Advatage and a small drawback.
@@Innozant yes sir
Thank you Sir
Itna achxa teach Karne k bawajud apka subscribe Kam hai
Views vi Kam
Akhir kyu ??
Koi nhi der s aayega viewed ko samajh .mujhme bht patience hai😊
@@Innozant ap k teach se Mai bahut impressive huwa Sir
Thank you sir
Very good function thanks for sharing this
Thanks dear😊🙏❤️
Hello Sir Main Aap ke Video se Aap se Bahut Kuch sikha hu me Aap ke Chanel pr ghanto bitata hu mujhe bhahut kuch milta hai sikhne ko.......Us k Liye Bhahut Bhahut Dil se thank's Dhanywad Aap ka.
Lekin Sir Ek Problem Aa Rahi hai jo aap ne (DGET) Function bataya ha bahut achcha hai lekin me is ko practical kar rha hu to kuch data to sahi aa rha hai lekin Kuch first ki 5 Entry me value #N/A Aa Rha Hai... Sir Esa Kyu...? baki row num. ka data sahi aa rha hai....🤔😊
Thanks
Sahi se apply kariye formula koi error nhi aayega
Sir if we want to get the result like this then we can use the filter formula which is even better dget formula.
V well explained
Sir, database or header ke bich me blank row ho to kya DGET function ko kaise kam karva sakte he ?
Please reply sir
Sir. All your video are worth watching. I am still learning excel. But passion with which you explains is awesome..
Thanks Javed ji for your valuable appreciation 🙏❤️
Please confirm this formula available in 2013 or not
Sir ji I know how to process vlookup /Xlooup and index match and now learned Dget. So how these functions are different from the the advanced filter. Ap ke paas aise koi video hai jise compare kar sake
🙏🙏🙏🙏You are doing hard work for us thank u so much
Thanks Lokesh 🙏❤️
Apke sare video dekhoga or lst tk kyu ke sare knowlege muje yha se available ho jayge
Is there any video about making of digital visiting card in excel ?
Sir can I do a job by seeing only your video without any certificate
Thanks Sir!
Sir ye dusre sheet se data extract karke le ayega sir ?
Then why should we use dget.
If there are any other advantages then please tell !!
Super ji.
❤️🙏
Sir can we use DGET on different sheet mean to say that can we give database argument to another sheet and bring the output to main sheet.
Thanks
Awesome Sir
Pls share advance DGET for mula to drag. Or to overcum its deficency
Good👌👌
Dear Sir, could you please help me, how can I set every print page total sum automatically?
Good sir
thanks Shiv
Make video on vendor reconsile ledger in excel or any excel utilitt
Ok .free time nikalke krta hu koshish
sir we can add (match function) in field side.
Yes Neha 👍
Cold i use Match function inside DGET
Sir good function for extract value
🙏😊❤️
Nice video
Thanks dear ❤️
Sir agar sumifs me do sum range kaise de
Sir is function se pehle vlookup ki knowledge jarori hai kya
Nhi to .. vlookup isse advanced version h dear
Nice 👌
Good
hello sir kya hum Dget se vlookup jaise complete record laasakte hain kya
Haan bilkul la skte h even reverse lookup bhi
@@Innozant sir please thora sa process bataye na complete record kaise lana hain
Wow! 😮 😮 😮
Thanks Pawan Ji..👍❤️🙏
Amazing 🙏🙏🙏
Thanks dear
Salute u sir g
Thanks Bhoopi. 🙏❤️😄
Sir. Plz share explain Dget function in detail.
👍
Osm
offcourse its availablw in office 2013
What a video sirji
Thanks Vinay❤️🙏😊
Sir ye bulk data ke ly kaise kam karta hai;?
Bulk ke loye vloolup use kariye
Sir koi aisa formula batao ki ( 1 cell me sirf 25 likhne se uska month and nad year aajaye) jaise 25 likhu to 25 March 2023 aajaye
Which office using brother u
M using Office 365 subscription based
Date pr work kaise krega pls batao
Dear sir please clear in which condition we use dget function
Kindly watch dget video.i already explained dear..ye vlookup ke substitute ke jagah use kr skte h
Dget is showing value error
Sir ye video only playlist me visible ho rha hai aur apke upload section me bhi nhi show ho rha aisa kyu.... Kuch time tak to private tha abhi ko basic Playlist me visible hua hai.... Aur iska notification bhi nhi aaya hai....
Uploaded ..Watch It Now
@@Innozant already watched 😀😎
Good
Sir Array ki video bna do plz
Seprate playlist available hai array & sumproduct ka
Sir teligram par bhi channel bnao
Ok..soon
I thought who knows VLOOKUP, that person is awesome in excel. par aaj pata chala ki vlookup to INDEX MATCH, NAMING RANGE, DGET, SUMPRODUCT ka bachcha hai..............😜🤣
Gm,abhi to Vlookup ke kitne saare Booster aane banki hain mere dost..Happy Learning.🙏🙏❤️❤️
🙏😍👍🏻
🙏❤️
I want latest Ms office plz send the link
If you want to use iffuce 365 you may use Web version..You may able thanks practice all latest formula of oddice 365
You may find office 2016 or 2019 download link are the in no. RUclips channel.Downloas and start your practice now
@@Innozant thanks sir
Sir ab to mera question solve kara diziye pls
Kaunsa Question reh gya ab aapka dear.
@@Innozant lucky @ abc. Com350
Kaur12@abc.com 650
659singh@abc.com
Output
Luck@abc. Com
Kaur12@abc.com
Singh @abc.com
Iska solution to bheja tha aapko..ok explanation ka video bna denge
@@Innozant sir video bana do na ,,,,,, ayse samj ni aa raha hai ki kaise hoga ...plss
Ek dout hai mujhe
Ask your doubt?
Mai apko WhatsApp send Kar duga record send Kar duga mujhe kahaa problem ho rahaa hai
Ok.sure
No volume
didn't get you
Questions mai
Good
♥️🙏
Sir can I do a job by seeing only your video without any certificate
Offcourse Yes...Skills is required
Ook sir and thx for that wonderful. And proper full course of Excel it is very helpful for me