Welcome to Digital Dcode! - www.digitaldcode.com
We are here to help you to learn Microsoft Excel, VBA Macro, Power BI, PowerPoint and MS-Access. Digital Dcode is one stop for all Microsoft reporting tools and our goal is to help you improve your technical and reporting skill which help you to project yourself better than senior in the organization. In this channel you can watch various topics, tips and techniques about Microsoft reporting tools, which help you finish work faster and save huge hours also it helps to grow in your career.
Our videos are about below Microsoft Reporting Tools:
1) Excel Basic to Advance Pro
2) VBA Macro with Automation
3) Power BI with DAX and Dashboard
4) PowerPoint with various Animation
5)MS-Access
Don't hesitate to post detailed comments on a specific video and I will try to assist you as best as possible.
Пікірлер
Excellent bro
Nice, thanks! It would be nice if you uploaded the sample file also so that we could practice with you. Thanks
Would be nice if there is no noise of keyboard buttons
Hii add in this formula Sumifs
Your explanation is bakwas... Can't understand
THX BRO, using
Brilliant! Cheers!
Excellent 👌
Thank you so much. This helped me!
Thank you so much!!! you help me a LOT!
Love you
i need to lookup two coloumn, one number and other general, how can i do it?
Very Nice Formula as well as your explanation sir. I have a Query: You took 1 by 1 each cell no. C5, D5, E5 & so on. Can't we take eg. C2:L5 ?
No...we can't do.
Amazing! Thanks, bro!
very helpful. exactly what I needed.
Nice
Great, appreciated
This is not a user FORM. You are misleading people.
Can i send one table for which i need xlookup formula
This is what i am looking for long time. Thanks
I cannot make this work and I have no idea why. if anyone is able to help, please let me know
i got what I looking for in just 2 min. thank you!!
Awesome straight to the point love your videos!!! Subscribed!
I have excel sheet , price according to number of persons , would like to get the price for the service I choose when i add how many persons I have
Thanks a million
Please teach us more conditional formatting for xlookups
Thanks brother for helping, can I use it for words also
This is so neatly explained. But I am struggling here with a model for say - in the data Angelina from Tax department has multiple managers (robin, mark, henry, martin, etc, there is no date to sort from) how can I just get a return value for say one particular manager? Can you help??
THANK YOUUUUUUUU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
This is what I was looking for. This saved me from delaying the task delivery. Thank you buddy.
Thankyou brother for this information. Now, I am able to find any information based on multiple criteria.
Thank you! This video is so helpful.
fix your fucking mic
Perfect 👍, please also share data file for practice
This is really great, it has solved my problem. Thank you so much.
Excellent. Thank you!
is this file downloadable
No
why do u freeze it?
Thank you for the example - this is precisely what I was looking for. All the other examples were using nested XLOOKUP formulae - which constantly returned a #VALUE or other #ERR - at least in my specific model.
I want to learn more master
Saved my butt, thanks!
Awesome video.Helped me solve the issue i was facing like a pro. Thank you soo much
Even after typing the same formula in multiple criteria, # N/A is coming… What is the reason?
Awesome! This is exactly what I needed! Thanks for posting 🙏
He keeps saying "freeze it"? when he adds the wildcards. How is he doing that?
Click F4- it freezes a cell location by adding $ to the column and row location
Hey.. this multiple criteria xlookup isn't working on my system (using 2021 ms office pro plus) shows #na, however, its working absolutely fine on web excel. Any idea whats the issue?
It should work. Not sure on the issue
You sir, made me do a happy dance. I had a lamda that I couldn't sync data between two tables. This fixed it so simply! Thank you!
what a life saver! thanks so much!
Thankx
1. Defining multiple variables in a single line makes everything a variant except the last variable 2. Never use the select command for anything 3. Never use Activecell 4. Use option explicit It might have been far better. It's a very naive implementation, Userform should have been a better option compared to ActiveX controls in the excel sheet.
UserForm is the true VBA-Excel programming.