DGET Function in Excel - Malayalam Tutorial
എക്സലിലെ VLOOKUP ഫോർമുലയ്ക്കു പകരം ഉപയോഗിക്കാൻ സാധിക്കുന്ന DGET ഫങ്ഷനെ കുറിച്ച് വിശദീകരിക്കുന്ന വീഡിയോ.
DGET Function in Excel explained in Malayalam.
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/microsof...
Subscribe to the channel for more
/ ajayanandxlncad
#ExcelMalayalam #MalayalamExcel #ExcelFormula
Пікірлер: 201
താങ്കളുടെ excel വീഡിയോ കൾ സസൂഷ്മമം മനസ്സിലാക്കി ഇന്ന് എനിക്ക് ഞങ്ങളുടെ ഓഫീസിൽ നല്ല നിലയിൽ work ചെയ്യാൻ സാധിക്കുന്നുണ്ട്. Thanks a lot for your great videos
@XLnCADMalayalam
2 жыл бұрын
Glad to hear that.
@youtubecomments1439
2 жыл бұрын
എനിക്കും
@binskpjose
2 жыл бұрын
@@XLnCADMalayalam /n
@harizabdulvahid3553
2 жыл бұрын
Enikkum🙌
ഇതിലും നല്ല അവതരണം ഇനി സ്വപ്നങ്ങളിൽ മാത്രം എന്തൊരു ലളിതം very very thanks
@XLnCADMalayalam
2 жыл бұрын
😀
ഞാൻ excel പുലിയാണ് എന്നായിരുന്നു എന്റെ വിശ്വാസം, VLoockup , index and match എല്ലാം ഭംഗിയായി ഉപയോഗിക്കാറുണ്ട്. എന്നാൽ സാറിന്റെ dget ക്ലാസ് എന്റെ കണ്ണ് തുറപ്പിച്ചു. വളരെ സിമ്പിളായി ഉപയോഗിക്കാവുന്ന ഫോർമുല, ലളിതമായി അവതരിപ്പിച്ചതിന് നന്ദി.
@XLnCADMalayalam
2 жыл бұрын
Thank you for kind words :)
@kurienillirickal7195
10 күн бұрын
Xlookup ഉപയോഗിക്കുന്നില്ലേ?
ഞാൻ 52 വയസ്സുള്ള ഒരു എക്സൽ വിദ്യാർത്ഥിയാണ് എനിക്ക് ഏറ്റവും കൂടുതൽ ഉപകാരപ്പെട്ടു നിങ്ങളുടെ വീഡിയോ
@XLnCADMalayalam
2 жыл бұрын
Glad to hear that 😀
I started watching your videos today only, within this short span of time I find lots of useful information, thanks brother
വളരെ നല്ല വീഡിയോ .. വലിയ ഡാറ്റാബേസ് ആണെങ്കിൽ DGET റൺ ആവാൻ കുറെ സമയം എടുത്ത് കാണുന്നുണ്ട്
You are such a pro in excel ...Thank you for sharing valuable information about excel keep doing it will help us to improve the skills in excel 😍😍
Thanks Sir, your all videos are useful, God bless you always. Expecting new video.
@XLnCADMalayalam
2 жыл бұрын
Thank your for your kind words :)
Super function…👍🏻👌🏻👌🏻
This is a very useful function, especially with the multiple arguments you can use. I will start using it now, thanks a lot for explaining this! Regarding vlookup, I find the combination of index and match to be a very good replacement.
Wow, simply awesome
@XLnCADMalayalam
2 жыл бұрын
Thank you! Cheers!
You are a great excel man, updating day by day is the most important thing...very supportive in my career. Thanks a lot dear.
Hi. Thanks for the valuable info. Inspite of being a regular user I hadn't heard about the DGET function so far. My doubt is whether this function is available in office 2016 or only in office 365 or office 2019
Appreciate your,,, your videos very much helpful my Job…
Thank you sir. Useful information.
@XLnCADMalayalam
2 жыл бұрын
My pleasure.
Thanks.. I was editing and preparing tables for Vlookup .. :D.. Now I can save that time..
@XLnCADMalayalam
2 жыл бұрын
Glad I could help!
Dget function seems to be very informative
Really professional...thanks and congrats.............
@XLnCADMalayalam
Жыл бұрын
Thanks and welcome😀
Sir avatharanam oru rakshayum illa. Ellavarkkum simple aayi manassilavunna rupathilulla avatharanam aan.❤❤
@XLnCADMalayalam
2 ай бұрын
😀 Thank you
Excellent presentation...👍👍👍
@XLnCADMalayalam
2 жыл бұрын
Thank you! Cheers!
Really helpful
Thank you. I like your teaching.
@XLnCADMalayalam
2 жыл бұрын
Glad to hear that
Very very useful. Thanks sir
@XLnCADMalayalam
2 жыл бұрын
My pleasure :)
Good and great explanation.
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
Very useful, thanks ….
@XLnCADMalayalam
2 жыл бұрын
You're welcome!
This is awesome 👍🏼
@XLnCADMalayalam
2 жыл бұрын
Thank you! Cheers!
Very useful thanks!
@XLnCADMalayalam
2 жыл бұрын
Glad to hear that!
Kidilan voice
i loved the explanation
@XLnCADMalayalam
2 жыл бұрын
Glad to hear that :)
Nice presentation!!
@XLnCADMalayalam
2 жыл бұрын
Thank you! Cheers!
Good presentation.keep going
@XLnCADMalayalam
2 жыл бұрын
Thanks a lot
Sir, i have a classwise table of railway fare, arranged horizontally in an order, 1.distance, 2.Ist Class, 3.IInd Ac, 4.IIIrd AC, 5.II SL. I just wanna find the rate of a specific class for a specific distance, and when i change the distance and class the fare should change corresponding to.. What formula or function i can use for that. I tried ur dget function, but didnt get.
Gud Info
Very nice presentation..
@XLnCADMalayalam
Жыл бұрын
😀
Very good information
@XLnCADMalayalam
Жыл бұрын
Happy to hear that ☺️
Useful 🙏
@XLnCADMalayalam
2 жыл бұрын
Glad to hear that :) Thank you
Thank you sir❤️
@XLnCADMalayalam
2 жыл бұрын
Most welcome
Thank u sir ❤️
@XLnCADMalayalam
2 жыл бұрын
You are welcome :)
Excellent
@XLnCADMalayalam
2 жыл бұрын
Thank you! Cheers!
Thank you sir😊
@XLnCADMalayalam
9 ай бұрын
Most welcome😀
Thanks sir
I had enrolled in ur udemy course too. Even there i couldn't find an apt formula or function. Can u please help me with this issue.
Thanks for sharing
@XLnCADMalayalam
2 жыл бұрын
My pleasure
Please do video about macros
Thank You!
@XLnCADMalayalam
2 жыл бұрын
You're welcome!
Thanks a lot
@XLnCADMalayalam
2 жыл бұрын
Most welcome
Same name ulla file copy cheyd desktopiled paste cheyyumbol desktopil munp ulla file replace cheyd poyi old file edukkan pattumo
Good. very informative
@XLnCADMalayalam
2 жыл бұрын
Glad it was helpful!
@XLnCADMalayalam
2 жыл бұрын
Glad it was helpful!
Good video 👍👍
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
Kudos✨️
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
Polli👌🏻👌🏻👌🏻
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
👍👍
👏
Usefull video
@XLnCADMalayalam
2 жыл бұрын
Glad you think so!
Thanks 👍
@XLnCADMalayalam
2 жыл бұрын
Welcome :)
thanks,how to give exact match in this formula
Sir, Excellent classes,, I need to bring the last balance of a table value to a different cell, wud u pls help me?
Pin to pin distance calculation excel ഫോർമുലകൾ ഉപയോഗിച്ച് കണ്ടു പിടിക്കാൻ സാധിക്കുമോ
Poli
Thank you
@XLnCADMalayalam
2 жыл бұрын
You're welcome
njn advanced Excel padipikunna teacher aanu, valare useful aanu, bakkiyulla database function ethrayum vegam idane
@XLnCADMalayalam
Жыл бұрын
😀👍
@dhanalekshmivs0511
Жыл бұрын
DTDEV, DSTDEVP AND DVAR FUNCTIONS ONNU UPLOAD CHEYANE PLZZ
Not only the duplicate values Dget will show number error if the values are partially match like HR&PR...am i right??
Thanks
@XLnCADMalayalam
2 жыл бұрын
😀 My pleasure
ഒന്നിൽ കൂടുതൽ സെയിൽസ് മൻ ഡാറ്റാ യിൽ നിന്നു ഓട്ടോമാറ്റിക് ആയി സെയിൽസ് മൻ നെയിം seprate ചെയ്യുന്ന വീഡിയോ ഇടാമോ(നെയിം ഫിൽറ്റർ ആയി പുതിയ ഷീറ്റ്റുകൾ)
Super
@XLnCADMalayalam
Жыл бұрын
😀
😊
Nice
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
Good 🥰
@XLnCADMalayalam
2 жыл бұрын
Thank you 🔥
Very interesting!!! Could you please do one on Index & Matching.
@XLnCADMalayalam
2 жыл бұрын
I have done a video on INDEX + MATCH formula. Please go through the videos section to find it.
@tomyjoseph775
2 жыл бұрын
@@XLnCADMalayalam Thanks will check
👍👍👍
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
🎉🙏
Can you let know one practical use case of Dget ()
How data capture from diffrent sheet.?
Dget function is available in old version??
A limitation of the DGET function is that you can’t pull the formula down using Fill Series to lookup multiple names to return multiple Designation and Departments.... so sad. i am working with thousands of data.... it is useless for me. better choice is index and match... Anyway thank you for a wonderful formula and your classes are very classy and easy to understand.
@XLnCADMalayalam
2 жыл бұрын
You are right. Database functions work like that. Moreover, DGET is not a substitute for VLOOKUP or INDEX+MATCH. For multiple matching records, I suggest referring my videos on XLOOKUP and 6 New Dynamic Array Functions.
@manojva07
2 жыл бұрын
yes exactly , no use case for this formula
@shahidkt2433
Жыл бұрын
Exactly..not a useful function who is looking a substitute for vlookup..and I didn't think its a useful function in our everyday work in excel.
Can we get data from another workbook?
Is there any recognized certification programs for Excel?
@XLnCADMalayalam
2 жыл бұрын
Yes. Microsoft has some Certification programs for Trainers. For example, Microsoft Office Specialist: Excel Associate
Thanks a lot. I have purchased your course and studying it now. Moreover I am following your videos and regularly practicing it now. But a small doubt എന്റെ വൈഫിന്റെ സ്കൂളിലെ കുട്ടികളുടെ മാർക്ക് ഒന്ന് സോർട്ട് ചെയ്യുന്നു. DGET Function ഉപയോഗിച്ച് ഒരു സബ്ജക്ടിന് ഏറ്റവും കൂടുതല് മാർക്ക് വാങ്ങിയ കുട്ടികളുടെ പേരു കണ്ട് പിടിച്ചു. പക്ഷേ രണ്ടോ അതിലധികമോ കുട്ടികൾക്ക് ഒരേ മാർക്ക് വന്നാല് എന്ത് ചെയ്യും.
Dget nammal engane രണ്ട് excel sheet il നിന്ന് extract cheyum
Sir, tutorial edukkumo
Multiple conditions satisfy cheyth oru value return aayi kittumo?? Any option??
@XLnCADMalayalam
2 жыл бұрын
Please check the 2rd and 3rd examples explained in this video.
Sir, i need your help Example 003/Adx/2021-22 /08.04.2022 I need invoice number in separate line and date in different line
@XLnCADMalayalam
2 жыл бұрын
Are you looking for line break? If so, Alt+Enter is the keyboard shortcut to add Line break in Excel.
i can't use this function multiple rows after scroll down,, please tell me any options to find result in multiple rows
@XLnCADMalayalam
Жыл бұрын
Check my video on the FILTER function in Excel.
Approx and exact match was a requirement
XLookup use cheyyu adh easy aan
Can we add a column of numbers that includes some sub totals but excluding the subtotal..
@XLnCADMalayalam
2 жыл бұрын
Use SUBTOTAL function to create subtotals.
@simisuresh7700
2 жыл бұрын
Can I use aggregate function for This purpose..
@simisuresh7700
2 жыл бұрын
Please suggest a video of aggregate function
@XLnCADMalayalam
2 жыл бұрын
Yes. You can use AGGREGATE function for this purpose.
@simisuresh7700
2 жыл бұрын
Please suggest an aggregate function video
DGET ഉപയോഗിച്ച് മൾടിപ്പിൾ ഡാറ്റ എസ്ട്രാക്ട് ചെയ്യാൻ പറ്റുമോ? ഉദാഹരണം ഒരു name koduthal ayalude underil ulla all bill numbers and the amount with date.
@XLnCADMalayalam
2 жыл бұрын
Illa. Database functions DGET, DSUM, DCOUNT won't work like that. I recommend the FILTER function in Excel for this purpose.
One name as reference with multiple values cheyyan enthu cheyyanam
@XLnCADMalayalam
2 жыл бұрын
Use the new FILTER function in Excel.
@agnosticpatriot
2 жыл бұрын
@@XLnCADMalayalam lookup function or index and Match using array cheyyan pattumo?
Can u share a video on Mail Merge?
@XLnCADMalayalam
2 жыл бұрын
Sure. in near future.
താഴോട്ട് സ്ക്രോൾ ചെയ്യുമ്പോൾ ആളുകളുടെ ഡാറ്റാ ഇതുപോലെ വരുന്നില്ല?
@XLnCADMalayalam
Жыл бұрын
I didn't get it. Scroll or Copy?
Important functionukal paranju tharamo
@XLnCADMalayalam
2 жыл бұрын
According to Microsoft the following are the 10 most Popular Excel Functions. SUM, IF, LOOKUP, VLOOKUP, MATCH, CHOOSE, DATE, DAYS, FIND and INDEX. Please go through the videos/Playlist sections of this channel for more on Excel Functions.
Sir enik cheythitt ithupole kittunnilla.. Value ennan varunnath..
@XLnCADMalayalam
2 жыл бұрын
I think your formula is returning #VALUE! Error. If so, please refer my video on Formula Errors in Excel.
വേഡ് 2010 ല് ഐഎസ്എം ഉപയോഗിച്ച് എങ്ങനെ മലയാളം ടൈപ്പ് ചെയ്യാം. 2007 വേര്ഷന് വരെ പ്രശ്നം ഇല്ലാരുന്നു. ഐഎസ്എം സെറ്റ് ചെയ്ത് മലയാളം ടൈപ്പ് ചെയ്യാന് വേഡ് 2010 മുതല് സാധിക്കുന്നില്ല. റിപ്ലേ തരാവോ.
Number to word work ആകുന്നില്ല, കാരണം എന്താകും?
സർ...എങ്ങനെ ആണ് ഒരു എക്സൽ ഷീറ്റ് ഓണ്ലൈനായി നിർത്തുക...
@XLnCADMalayalam
2 жыл бұрын
Use Excel Online (Excel for web)
Dget ഇൽ numbers sum ചെയ്യാൻ കഴിയോ
@XLnCADMalayalam
2 жыл бұрын
For Sum you should use DSUM function.
Sir ഈ വീഡിയോയിലെ ആദ്യത്തെ data ഉദാഹരണം ആയി എടുത്ത് താഴെ പറയുന്ന കാര്യം ചെയ്യാൻ പറ്റുമോ Manager എന്ന designation ഉള്ള എല്ലാ employees ൻ്റെ പേര് വേറെ worksheetil കിട്ടുന്ന രീതിയിൽ pls (vlook up 1st match മാത്രമേ കിട്ടുന്നുള്ളൂ)
@XLnCADMalayalam
2 жыл бұрын
I suggest to use FILTER function for this purpose. Check my video on the new dynamic array functions in Excel. FILTER function is one among them.
@jokerstudio7075
2 жыл бұрын
@@XLnCADMalayalam കിട്ടി 👍 സാധനം സാധാരണക്കാരന് കിട്ടില്ല 365 users only ബൂർഷ്വാ microsoft 💰💰💰😭😭😭
@jokerstudio7075
2 жыл бұрын
@@XLnCADMalayalam ഇത് വല്ല macro recorder വഴി older excel versionsil ചെയ്യാൻ പറ്റുമോ
Multiple matches findചെയ്യാനുള്ള ഒരു ഫോർമുല പറഞ്ഞു തരുമോ
@XLnCADMalayalam
2 жыл бұрын
I think I have done videos on this topic. Please go through the videos section of this channel and search for the videos on VLOOKUP.
@nikhil8724
2 жыл бұрын
Xlookup.
Whether this function can use for multiple raw at same time just like VLookup? Or it can apply only one cell?
@XLnCADMalayalam
2 жыл бұрын
Formula created using DGET function can't be copied into adjacent rows. This is one of the few drawbacks of Database functions.