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. TH-cam 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
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❤️
this is such a great Fn , kabhi use nhi kia tha maine , now its so handy to use...! Respect
👍😊
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
Thanks sir, wonderful video. Aap bhut Achha samjhate ho. Again thanks
Thanks Mohit Ji👍🙏Have a great day ahead.Practice jaroor kiya kijiye regular
Bahot baria andaz hay bhai...... Allah khush rakhay apko
Thanks dear.Happy learning ❤️
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.
Your teaching method is superb sir💐
Thanks
Simplified एंड ट्रांसपरेंट टीचिंग सर❤
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
super say bhi upar vlookup say best h formula h 👌🏻👌🏻
Thanks Karan🙏😊❤️
I like your teaching approach, thank you so much.
Thanks dear..Happy Learning ❤️
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🙏❤️😊
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
सर , यु टयूब पर Excel के काफी विडियो देखे हे पर उसमे वह चीज नही मिलती जो आप के विडियो मे मिलती हे और वह हे आपकी Smile सर आप यु ही विडियो बनाते रहे
Thanks dear itne pyare aur valuable appreciation ke liye..God bless you dear
बहुत बढ़िया है 👍
❤️😊🙏
Ek number sir 👌👌👌👌
Very good function thanks for sharing this
Thanks dear😊🙏❤️
🙏🙏🙏🙏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
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
Thank you sir
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
Sir if we want to get the result like this then we can use the filter formula which is even better dget formula.
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 🙏❤️
V well explained
Is there any video about making of digital visiting card in excel ?
Sir, database or header ke bich me blank row ho to kya DGET function ko kaise kam karva sakte he ?
Please reply sir
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 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
Then why should we use dget.
If there are any other advantages then please tell !!
Sir ye dusre sheet se data extract karke le ayega sir ?
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.
Please confirm this formula available in 2013 or not
Sir good function for extract value
🙏😊❤️
Thanks Sir!
sir we can add (match function) in field side.
Yes Neha 👍
Sir can I do a job by seeing only your video without any certificate
Sir agar sumifs me do sum range kaise de
Make video on vendor reconsile ledger in excel or any excel utilitt
Ok .free time nikalke krta hu koshish
Awesome Sir
Cold i use Match function inside DGET
Thanks
Pls share advance DGET for mula to drag. Or to overcum its deficency
Dear Sir, could you please help me, how can I set every print page total sum automatically?
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
Nice video
Thanks dear ❤️
Sir is function se pehle vlookup ki knowledge jarori hai kya
Nhi to .. vlookup isse advanced version h dear
Good sir
thanks Shiv
Date pr work kaise krega pls batao
Nice 👌
Amazing 🙏🙏🙏
Thanks dear
Good
Sir ye bulk data ke ly kaise kam karta hai;?
Bulk ke loye vloolup use kariye
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
Salute u sir g
Thanks Bhoopi. 🙏❤️😄
Which office using brother u
M using Office 365 subscription based
Sir. Plz share explain Dget function in detail.
👍
Dget is showing value error
What a video sirji
Thanks Vinay❤️🙏😊
Wow! 😮 😮 😮
Thanks Pawan Ji..👍❤️🙏
Osm
offcourse its availablw in office 2013
Sir Array ki video bna do plz
Seprate playlist available hai array & sumproduct ka
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 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
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.🙏🙏❤️❤️
Sir teligram par bhi channel bnao
Ok..soon
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
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. TH-cam channel.Downloas and start your practice now
@@Innozant thanks sir
🙏😍👍🏻
🙏❤️
No volume
didn't get you
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
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