Khurram Khan
Khurram Khan
  • 418
  • 448 457
How to use VLOOKUP Function to Retrieve Data from Different Sheets or a different Workbook
If you are new to my channel, please subscribe and press the bell icon too.
Thank you for watching!
🅻🅸🅺🅴----🆂🅷🅰🆁🅴-----🅲🅾🅼🅼🅴🅽🆃------🆂🆄🅱🆂🅲🆁🅸🅱🅴
Featured playlist.
ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html
Visit my other Videos too:
Power BI Full Tutorial 2023:
ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html
Power Query:
ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html
3D formula:
ua-cam.com/play/PL3Tm2R487bMf0ZHltQUOqByAMLH0HzHHG.html
Alt-Enter:
ua-cam.com/play/PL3Tm2R487bMcNTm0100lzmO6P12gG56JW.html
Aggregate and Subtotal:
ua-cam.com/play/PL3Tm2R487bMdRudDcEi_J0fFbu9BqmCK_.html
Logic Function:
ua-cam.com/play/PL3Tm2R487bMf_pY_DpJVjOZmk1Ba1DTbF.html
Excel Worksheet links:
ua-cam.com/play/PL3Tm2R487bMePXqQ4T_3pIT4iRo_sp2wf.html
Mail Merge:
ua-cam.com/play/PL3Tm2R487bMcoEMxr1WJEU1DqhvIm2gxw.html
Dilemma:
ua-cam.com/play/PL3Tm2R487bMc_D-7KDgbceqNZ1axo0Teg.html
Excel tips and tricks:
ua-cam.com/play/PL3Tm2R487bMcZ_1bsXilLHXn6wcCTiabc.html
Questions on Categorical Syllogism:
ua-cam.com/play/PL3Tm2R487bMf-W4dR3JZWA0bbLEx9fiZI.html
Information Systems Basic:
ua-cam.com/play/PL3Tm2R487bMdsEAMP_-Fu89NtVd8V7Ede.html
Переглядів: 52

Відео

Symbolic Representation of Conjunction Disjunction Negation and Implication Exercises and Solution
Переглядів 22814 днів тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
COUNT, COUNTIF and COUNTIFS Functions
Переглядів 15221 день тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
Pointer to a Function
Переглядів 3786 місяців тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
Increment or Add a Value to All the values of a selected range in Few Clicks
Переглядів 4486 місяців тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
Pointer to a Structure
Переглядів 2726 місяців тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
What is Structure and how we can define and use it
Переглядів 2436 місяців тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
Dynamic Memory Allocation
Переглядів 3116 місяців тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
Static and Normal Variables
Переглядів 2716 місяців тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
Autofill Ranges with Series
Переглядів 2726 місяців тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
Pass and Return an array using pointer variable with a simple function
Переглядів 3356 місяців тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
How to Pass an array to pointer variable as function argument to process an array to return average
Переглядів 3666 місяців тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
Present your Bullet Points with Fade and Fly In Animation to maintain focus of your audience
Переглядів 1777 місяців тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
Calculate Sum of Arrays Values using Pointers
Переглядів 3317 місяців тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
Pointer Arithmetic Array and Pointers
Переглядів 2937 місяців тому
If you are new to my channel, please subscribe and press the bell icon too. Thank you for watching! 🅻🅸🅺🅴 🆂🅷🅰🆁🅴 🅲🅾🅼🅼🅴🅽🆃 🆂🆄🅱🆂🅲🆁🅸🅱🅴 Featured playlist. ua-cam.com/play/PL3Tm2R487bMdC90LBiBE2ol6rkKfuhM1i.html Visit my other Videos too: Power BI Full Tutorial 2023: ua-cam.com/play/PL3Tm2R487bMd51cFyGAEKX4Gk6CIwCzoH.html Power Query: ua-cam.com/play/PL3Tm2R487bMdekFyCi0Mc_dtnXlQQrOdC.html 3D formula: ...
Pointer Basic Concept
Переглядів 3367 місяців тому
Pointer Basic Concept
Understanding Double Dimensional Arrays with Solving Matrix Addition Problem
Переглядів 3507 місяців тому
Understanding Double Dimensional Arrays with Solving Matrix Addition Problem
How to Create and use Custom Header file that contains some text functions
Переглядів 2687 місяців тому
How to Create and use Custom Header file that contains some text functions
How to Pass an array to a function that will return the largest number
Переглядів 3507 місяців тому
How to Pass an array to a function that will return the largest number
Character Case Conversion Logic
Переглядів 3107 місяців тому
Character Case Conversion Logic
Concatenated Two Strings
Переглядів 3407 місяців тому
Concatenated Two Strings
How to get ASCII Code by Typing a specific Character
Переглядів 2767 місяців тому
How to get ASCII Code by Typing a specific Character
How to store a string or a sentence with spaces in a character array
Переглядів 2957 місяців тому
How to store a string or a sentence with spaces in a character array
Basic Concept of Character Array
Переглядів 3267 місяців тому
Basic Concept of Character Array
ASCII to Character and Vice Versa
Переглядів 3007 місяців тому
ASCII to Character and Vice Versa
Character Array Processing to Reverse a String
Переглядів 3227 місяців тому
Character Array Processing to Reverse a String
Understanding Bubble Sort with Single Dimension Arrays
Переглядів 4667 місяців тому
Understanding Bubble Sort with Single Dimension Arrays
Different ways to Initalize an array and Processing wtih example
Переглядів 3507 місяців тому
Different ways to Initalize an array and Processing wtih example
Arrays Basic Idea with a simple example
Переглядів 3177 місяців тому
Arrays Basic Idea with a simple example
Nested Loop with DO While
Переглядів 2407 місяців тому
Nested Loop with DO While

КОМЕНТАРІ

  • @MuhammadHamza-cg8if
    @MuhammadHamza-cg8if 12 годин тому

    MashaAllah It is very helpful for us . Thanks you Sir 2:02

  • @Aryaaaaaaaaa
    @Aryaaaaaaaaa 12 днів тому

    Thank you so much 😊

  • @neeraj21750
    @neeraj21750 16 днів тому

    Informative video

  • @ipconfigearth102
    @ipconfigearth102 Місяць тому

    Next step? Video pls

  • @toaipham9051
    @toaipham9051 Місяць тому

    I came accross some instructions for the same issue but this instruction is very understandable. THANK YOU!

  • @abhi2662
    @abhi2662 Місяць тому

    Sir after doing all this process can we remove blank cells from every page of result.

  • @MrAmakikkin
    @MrAmakikkin Місяць тому

    What to do if some values are duplicates and some or not?

  • @UmarGujjar-e2n
    @UmarGujjar-e2n 3 місяці тому

    Waw g

  • @ParvejKhan-bu3sp
    @ParvejKhan-bu3sp 3 місяці тому

    Had watched many videos but this video actually helped me to clear my doubt properly. Thank You sir !

  • @nafeesahmadfixansweralgebr8298
    @nafeesahmadfixansweralgebr8298 3 місяці тому

    Good

  • @pkgoodfriend
    @pkgoodfriend 3 місяці тому

    While entering bill no or value from mail merge you are getting data in {} and we are getting in <> , also after set id code if i am inserting amount it is becoming blank

  • @Islamic-Naats-n-Video-Channel
    @Islamic-Naats-n-Video-Channel 4 місяці тому

    MashaAllah U R Gem ❤️❤️❤️

  • @akshaynm
    @akshaynm 4 місяці тому

    Very Nice Tutorial Sir, Thanks a lot 🙏🏻

  • @mominaasim8879
    @mominaasim8879 4 місяці тому

    thank you so much sir meri problem solve ho gayi is video ko daikh kay.

  • @waseemafzal1001
    @waseemafzal1001 4 місяці тому

    great

  • @lien355
    @lien355 5 місяців тому

    Sir, does it work for mail merge tool kit too?

  • @kamrankarsaz8952
    @kamrankarsaz8952 5 місяців тому

    thank you

  • @guri133
    @guri133 5 місяців тому

    I have query can you share your no.

  • @Tiwaripratiksha89
    @Tiwaripratiksha89 5 місяців тому

    Which PowerPoint office is this

  • @noorshiekh8348
    @noorshiekh8348 5 місяців тому

    Very informative, Thanks I was looking for this one.

  • @bvvjgguj7102
    @bvvjgguj7102 6 місяців тому

    I cry my self to sleep every night

  • @raufsaeed2799
    @raufsaeed2799 6 місяців тому

    Your conversation is based upon Bloom's Taxonomy in the title of critical thinking skill.

  • @sridevi-ge1tg
    @sridevi-ge1tg 6 місяців тому

    Thank you so much for the Video. I have added the { =Sum(Above)} .But it is not adding the numbers,it is displayed as it is in the mail merge document.What might be the issue

  • @Blockbuster.Hub514
    @Blockbuster.Hub514 6 місяців тому

    Good but sound quality need yo improve

  • @allahnoortareen9747
    @allahnoortareen9747 7 місяців тому

    plz send a backup file so i will runt it myself perhaps your assistance will need in this regard

  • @DarshitValia
    @DarshitValia 7 місяців тому

    Just came across this great tutorial and used it on my data table. However, I had a question. The Test column has a 1 or 0 based on the start and stop on the group. What happens if there is a SINGLE ENTRY? The TEST column basically inputs a 0. It would be great if you could help me out on this.

    • @lakshmikulkarni9605
      @lakshmikulkarni9605 4 місяці тому

      did you find a solution for this? I have the same question

  • @deepakmutalik3788
    @deepakmutalik3788 8 місяців тому

    Hi Sir if I want to blank table then what is the code

  • @maryamraiz1703
    @maryamraiz1703 8 місяців тому

    Sir solve bi Tu kry question

  • @sharifulislam7441
    @sharifulislam7441 9 місяців тому

    What if last row that VICK is deleted and so only one record is for VICK? In that case this formula will definitely fail though real world data might be so.

  • @SiddhantRaiSK
    @SiddhantRaiSK 9 місяців тому

    If clause is not working,

  • @sharonlim2895
    @sharonlim2895 9 місяців тому

    Thanks for video, instruction is clear. I used it to merge over 1K docs. Some letters created had blank on some rows, others look good. What could be the problem?

  • @HabibUllahqamar
    @HabibUllahqamar 10 місяців тому

    I am thankful to you sir. Salute

  • @IanisRenier
    @IanisRenier 10 місяців тому

    merci le boss !

  • @shaheenmahmud5884
    @shaheenmahmud5884 10 місяців тому

    Can you please help how can I get "same data table" in the multiple word pages

  • @jaysee27
    @jaysee27 10 місяців тому

    Finally!!!😁. A video that shows and clearly explains this type of process; and it actually works! Thank You!!!! There is so much info on this topic online but I couldn't find a process that actually explains and shows it this clearly and works. I had actually given up on this process as an option. After all these years, you would think MS would have come up with this function as part of the standard Mail Merge. Thank you again.

  • @ShahZaib-l3j
    @ShahZaib-l3j 10 місяців тому

    ❤❤

  • @prasenjitchatterjee2787
    @prasenjitchatterjee2787 10 місяців тому

    @khurram sir...aapse ek urgent help chahiye Ek mail merge banane ke liye....main aapse phone pe baat kar sakta hun kya??

  • @javalearner4227
    @javalearner4227 10 місяців тому

    Keep creating new videos!! Thanks explained well without any distractions.

  • @karlabruce2871
    @karlabruce2871 11 місяців тому

    Thank you thank you! This is exactly what I needed. Thank you for such a detailed explanation!

  • @shaniasharma473
    @shaniasharma473 11 місяців тому

    How can I remove the extra blank lines in the table under multiple records?

  • @yutikasingh7687
    @yutikasingh7687 11 місяців тому

    🎉🎉

  • @Vivacious197
    @Vivacious197 11 місяців тому

    Hello Please I need help with this task and its urgent. I have a data sources(excel file) with variable length table i want to merge blocks of fields into a single word document and I don't know how to achieve this task

  • @garyrowe58
    @garyrowe58 11 місяців тому

    Thank you so much, I saw so many convoluted and confusing videos before I found this, and now I understand what I need to do ... at last!!!!

  • @roylopez6892
    @roylopez6892 11 місяців тому

    Thank you very much for this video, I've been looking for this solution for months, and this helps me a lot.

  • @frightrisk7407
    @frightrisk7407 Рік тому

    Is there any way to avoid having to use a "helper"column? Surely there must be a way to check if the last record field and the field in the record after are different and proceed that way.

  • @anooshkhan3999
    @anooshkhan3999 Рік тому

    I tried and it works. Excellent!

  • @SaymaSultana-w9m
    @SaymaSultana-w9m Рік тому

    How to send email to different people with this different grouping data table to those specific person? Please answer.

  • @SureshKumar-x6s5h
    @SureshKumar-x6s5h Рік тому

    Good explanation 👍

  • @andrehinds5910
    @andrehinds5910 Рік тому

    Hello Khurram Khan, I am really greatful for your content. I watched a video you did on mail merging by grouping related records and need some assistance. Would you be able to have some time to share some insites with me? I need some assistance with mail merging related records to individual pdfs and them mailing them out as pdf attachments.

  • @PavolMalinovský
    @PavolMalinovský Рік тому

    Hello Mr. Hkurram Khan, I am not able to reproduce your tutorial. I am not able to correctly evaluate if the ID1 and ID2 are the same or not. The result of comparison is wrong (ID1 = ID2) even if it is not true. This way the word do not list next records (with test =1). -> I have changed the logic of if function -(> if ID1=ID2, insert merged fiield, "") and I am getting the next records (solved), but the next record if (test =0) does not work and is listing last record repeatadly. Please do you have any Idea, what am I doing wrong? thank you. Pavol