Excel How To Compare Two Tables in a Second

Поделиться
HTML-код
  • Опубликовано: 22 авг 2015
  • Get full course with discount:
    www.udemy.com/excel-ninja-tri...

Комментарии • 17

  • @jonchapman621
    @jonchapman621 3 года назад +1

    Thanks for sharing!!! I watch yours and Vanna Excel for my marketing work!

  • @cambike
    @cambike 5 лет назад +5

    If you converted to table CTRL or Command T, it would automatically add column and copy your formula in all rows, much quicker :)

  • @alexrosen8762
    @alexrosen8762 7 лет назад +1

    Very useful. Thanks for sharing :-)

  • @marinastreletska8441
    @marinastreletska8441 8 лет назад +1

    Thanks! :)

  • @meg8584
    @meg8584 7 лет назад

    thanks a ton! :)

  • @ashokkhatri8577
    @ashokkhatri8577 3 года назад +2

    very usefull information

  • @brahimeljaidi6229
    @brahimeljaidi6229 2 года назад

    Hello to all; I thank you for your clarity it is really very rich
    I am a student and I am working on my final year project, I am working on the opportunity of adopting "economic xx" policies in a context of crisis.
    I seek through this subject to study on the one hand the performance of these policies and on the other hand predict its adoption in Morocco
    I would like to know, can I use this method of waht if style to analyze the said subject?
    I would like to know if I can use this waht if method to analyze the subject?
    I need your help
    Thank you very much for you and for all
    Brahim el jaidi

  • @RahulKumar-ly6ly
    @RahulKumar-ly6ly 2 года назад

    Thanks sir

  • @Dalimscreative
    @Dalimscreative 2 года назад

    Nice video

  • @AliRaza-lr3jq
    @AliRaza-lr3jq 5 лет назад +2

    i have 2 sheets in 1 sheet multiple data with same items, and other sheet i want to found same data is not available. Example is given below.
    1st sheet
    Item Warehouse_Code
    02319897 DTC-GR1SRR
    02319897 DTC-GR1NJR
    02319897 DTC-GR1MHY
    02319897 DTC-GR1JZN
    02319897 DTC-GR1KMS
    02319897 DTC-GR1BSH
    02319897 DTC-GR1ABH
    2nd sheet
    Subinventory Item
    DTC-GR1JZN 02319897
    DTC-GR1MHY 02319897
    DTC-GR1NJR 02319897
    DTC-GR1SRR 02319897

  • @estebanmarin002
    @estebanmarin002 7 лет назад +10

    You said compare in a second, and true computational time can be less than a second, however, the explanation was unbearable I could not get through all the 6 minutes even though the information seems very relevant!

    • @randyrandom2386
      @randyrandom2386 6 лет назад +1

      Agree! here is the easiest way I have found so far ruclips.net/video/ZBBtqQ_AxMs/видео.html

    • @timtheli0n
      @timtheli0n 5 лет назад +3

      I found it helpful and I am grateful that the uploader took the time to make the video.

    • @7thenumberofmagic
      @7thenumberofmagic 5 лет назад

      Maybe his watch was broken?

    • @jonchapman621
      @jonchapman621 3 года назад

      And I feel you can use VLOOKUP in this way ruclips.net/video/W8tvPNN2cK4/видео.html

  • @cambike
    @cambike 5 лет назад +2

    If you converted to table CTRL or Command T, it would automatically add column and copy your formula in all rows, much quicker :)