Digital Dcode

Digital Dcode

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.

Пікірлер

  • @rambabudodda2975
    @rambabudodda29758 күн бұрын

    Excellent bro

  • @shoppersdream
    @shoppersdream14 күн бұрын

    Nice, thanks! It would be nice if you uploaded the sample file also so that we could practice with you. Thanks

  • @8446510709
    @8446510709Ай бұрын

    Would be nice if there is no noise of keyboard buttons

  • @shyamallrounder
    @shyamallrounderАй бұрын

    Hii add in this formula Sumifs

  • @ateeqahd
    @ateeqahd3 ай бұрын

    Your explanation is bakwas... Can't understand

  • @afifp
    @afifp3 ай бұрын

    THX BRO, using

  • @yulinliu850
    @yulinliu8504 ай бұрын

    Brilliant! Cheers!

  • @sam23058
    @sam230585 ай бұрын

    Excellent 👌

  • @himavanthkumar5269
    @himavanthkumar52697 ай бұрын

    Thank you so much. This helped me!

  • @user-rv3ck5no5q
    @user-rv3ck5no5q11 ай бұрын

    Thank you so much!!! you help me a LOT!

  • @hafiz786nasir
    @hafiz786nasir11 ай бұрын

    Love you

  • @mohamedmahboob2996
    @mohamedmahboob2996 Жыл бұрын

    i need to lookup two coloumn, one number and other general, how can i do it?

  • @brtsharma7240
    @brtsharma7240 Жыл бұрын

    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 ?

  • @DigitalDcode
    @DigitalDcode Жыл бұрын

    No...we can't do.

  • @icsos
    @icsos Жыл бұрын

    Amazing! Thanks, bro!

  • @graceisraa
    @graceisraa Жыл бұрын

    very helpful. exactly what I needed.

  • @gumnaam6068
    @gumnaam6068 Жыл бұрын

    Nice

  • @AhmedNabil-pq6eo
    @AhmedNabil-pq6eo Жыл бұрын

    Great, appreciated

  • @Info-God
    @Info-God Жыл бұрын

    This is not a user FORM. You are misleading people.

  • @arunborgave6640
    @arunborgave6640 Жыл бұрын

    Can i send one table for which i need xlookup formula

  • @vasu4ug
    @vasu4ug Жыл бұрын

    This is what i am looking for long time. Thanks

  • @wj04
    @wj04 Жыл бұрын

    I cannot make this work and I have no idea why. if anyone is able to help, please let me know

  • @iamjerose-oldchannel
    @iamjerose-oldchannel Жыл бұрын

    i got what I looking for in just 2 min. thank you!!

  • @imahodler
    @imahodler Жыл бұрын

    Awesome straight to the point love your videos!!! Subscribed!

  • @Magedalshaer
    @Magedalshaer Жыл бұрын

    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

  • @keletsoselala404
    @keletsoselala404 Жыл бұрын

    Thanks a million

  • @amitbhandari9498
    @amitbhandari9498 Жыл бұрын

    Please teach us more conditional formatting for xlookups

  • @amitbhandari9498
    @amitbhandari9498 Жыл бұрын

    Thanks brother for helping, can I use it for words also

  • @charuv2335
    @charuv2335 Жыл бұрын

    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??

  • @2CrazyBlueEyes
    @2CrazyBlueEyes Жыл бұрын

    THANK YOUUUUUUUU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  • @kdotkrishna6944
    @kdotkrishna6944 Жыл бұрын

    This is what I was looking for. This saved me from delaying the task delivery. Thank you buddy.

  • @joanarun1
    @joanarun1 Жыл бұрын

    Thankyou brother for this information. Now, I am able to find any information based on multiple criteria.

  • @myytube168
    @myytube168 Жыл бұрын

    Thank you! This video is so helpful.

  • @EliminateHD
    @EliminateHD Жыл бұрын

    fix your fucking mic

  • @usmaniqbal1836
    @usmaniqbal1836 Жыл бұрын

    Perfect 👍, please also share data file for practice

  • @francisosilo3188
    @francisosilo3188 Жыл бұрын

    This is really great, it has solved my problem. Thank you so much.

  • @silmarti
    @silmarti Жыл бұрын

    Excellent. Thank you!

  • @irenesanjay
    @irenesanjay Жыл бұрын

    is this file downloadable

  • @DigitalDcode
    @DigitalDcode Жыл бұрын

    No

  • @timloi3932
    @timloi3932 Жыл бұрын

    why do u freeze it?

  • @IamChevalier
    @IamChevalier Жыл бұрын

    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.

  • @blinkwinkenterprises8056
    @blinkwinkenterprises80562 жыл бұрын

    I want to learn more master

  • @TheCluelessReefer
    @TheCluelessReefer2 жыл бұрын

    Saved my butt, thanks!

  • @niranjan0066
    @niranjan00662 жыл бұрын

    Awesome video.Helped me solve the issue i was facing like a pro. Thank you soo much

  • @vikkyghale912
    @vikkyghale9122 жыл бұрын

    Even after typing the same formula in multiple criteria, # N/A is coming… What is the reason?

  • @jackplunderbones
    @jackplunderbones2 жыл бұрын

    Awesome! This is exactly what I needed! Thanks for posting 🙏

  • @justindurlewanger4209
    @justindurlewanger42092 жыл бұрын

    He keeps saying "freeze it"? when he adds the wildcards. How is he doing that?

  • @jenniferg1747
    @jenniferg17478 ай бұрын

    Click F4- it freezes a cell location by adding $ to the column and row location

  • @shivamsonkar2719
    @shivamsonkar27192 жыл бұрын

    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?

  • @DigitalDcode
    @DigitalDcode2 жыл бұрын

    It should work. Not sure on the issue

  • @Elwulven
    @Elwulven2 жыл бұрын

    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!

  • @eliflondrada
    @eliflondrada2 жыл бұрын

    what a life saver! thanks so much!

  • @srinidhim7978
    @srinidhim79782 жыл бұрын

    Thankx

  • @VipulKarkar
    @VipulKarkar2 жыл бұрын

    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.

  • @Info-God
    @Info-God Жыл бұрын

    UserForm is the true VBA-Excel programming.