Using the DGET Formula in Excel in hindi | Excel DGET Function Solves of Your VLOOKUP Problems
HTML-код
- Опубликовано: 11 сен 2024
- Your learn in this video How to Use the DGET Formula in Excel in hindi | Excel DGET Function Solves of Your VLOOKUP Problems. Excel DGET Function is one of Excel's "forgotten" database functions that can do a Left lookup (unlike VLOOKUP) and ALSO easily look for multiple criteria. Little known Function in Excel that is better than VLOOKUP or INDEX + MATCH
#dgetfunction #dgetinexcel #advancedexcel
www.amazon.in/shop/computergyanguruji
Canon Dslr:- amzn.to/3ad4lIx
Tripod:- amzn.to/3aitaTJ
Generic 3.5mm Lapel Mic:- amzn.to/3cbqV6e
Boya M1 Mic:- amzn.to/2wPLtku
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
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic
1. DGET is an easy formula - Excel DGET expalined
2. DGET can look for approximate matches
3. DGET can look for OR conditions - If either condition is met
4. DGET can match multiple criteria
5. DGET can lookup values to the left
6. DGET acts like an automatic filter
bahut badiya Sir ji. thanks
Your explanation with questions by yourself make the concept much clear. Thank u sir.
Super support 🙌💪
Good video sir
थैंक्स सर।
Thank you गुरूजी... आप ने नया function सिखाया
Nice
Thank you sir. 🙏🙏
Nicely explained Sir
Good Sir
Jhakash video sir
Super video boss
NICE CLASS SIR
Please use this data with dget horizentally
Sir ji apne filter kaise lagaya automatically
sir dget aur index formula office 2010 me nahi work kr raha hai
pls help me sir
Sir Mera top ke column me formula lag Jata hai mager uske baad kisi bhi column me kaam nahi ker raha kya ho raha hai
Sir, mai ek invoice banaya hu usme brand name or product name ka use kar k ek dependent drop down banaya hu mai ye chahta hu ki dget function use kar k rate ko fatch karu lakin ye sirf ek hi cell me ho raha hai aage dusre cell me formula copy karne par error ho raha hai kya kare..
Do something for office people, not only school
Sir kya yeh formula sirf ek hi row mein kaam krta hai, m isko drag kr rha hun toh neeche #Num error aa rha hai
What About Duplicate Same Father Name in Same Address ?
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".
How to use dget formula horizontally in Excel/ Google sheets.
criteria ko lock kaise kare
Fromule ko drag kese kre
Are bhai yeh pure sheet may nahi Lagra ak he line may
Nice explained Sir ,🙏