How to Sort and Synchronize two list together and align two set of Data in Microsoft Excel

Поделиться
HTML-код
  • Опубликовано: 26 окт 2024

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

  • @Boogle_123
    @Boogle_123 9 месяцев назад +7

    Searched for days before coming across this tutorial. Finally, in one video someone was able to explain what I needed to do and explained it well

  • @Stevo1361
    @Stevo1361 Год назад +4

    It's already been said but I'll say it again, you're an absolute legend! I can't tell you how many articles and videos I watched before finding this one. None came close to being what I needed, this was relatively simple and perfect for the job.

    • @EXCELDOERS
      @EXCELDOERS  Год назад +1

      Thank you. I can't explain how much energy and motivation I receive from such feedback.
      For any further support query or custom services. Don't hesitate to reach me at
      Exceldoers@gmail.com

  • @sowmyad9873
    @sowmyad9873 2 года назад +4

    You are a savior for me today. Thanks a ton for your videos!

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

    You are an absolute legend my friend, from this video.... I have just done some Godly things in Excel!
    Fantastic tutorial and easy to follow, thank you!:)

  • @aftabalamusmani2020
    @aftabalamusmani2020 9 месяцев назад +1

    Thank you so much for solving my year-long problem in just few minutes

    • @EXCELDOERS
      @EXCELDOERS  8 месяцев назад

      Great. Share with others

  • @Damien1_1
    @Damien1_1 Год назад +2

    Uff! Finally found the one video I was looking for!! I know Vlookup but knowing how to use it in every possible way is not something I know well. Many thanks to you!!!!💖💝

    • @EXCELDOERS
      @EXCELDOERS  Год назад +1

      Thank u. Explore our channel for more great videos

  • @thecolossalworld
    @thecolossalworld Год назад +1

    You are simply awesome Bro.Thank you so much for saving all of our time.And please upload more and more videos on excel.

  • @sharanyaissac5005
    @sharanyaissac5005 2 года назад +2

    Thanks! This video just solved my problem 😅 keep making such helpful videos

  • @russellwordsworth8423
    @russellwordsworth8423 Месяц назад

    You're a legend mate. Simply and easy instructions to solve my problems. Thanks!

  • @BethGardnerPPS
    @BethGardnerPPS Год назад +1

    Thank you for making this so straightforward! This was perfect for my needs.

  • @gato2002
    @gato2002 День назад

    Thanks, you helped me a lot.

  • @jacksondo55
    @jacksondo55 2 года назад +2

    I was looking for this! You're a life saver. Subbed and liked.

  • @odjo17
    @odjo17 6 месяцев назад

    this is magic. Thank you so much for sharing

  • @Engel990
    @Engel990 8 месяцев назад +1

    You just saved me my job. Have a like and sub.

    • @EXCELDOERS
      @EXCELDOERS  8 месяцев назад

      Enjoy.. explore more our channel and share with others

  • @pathansami
    @pathansami Год назад +1

    This was an extremely helpful video. Thank you!

  • @feitw
    @feitw Год назад

    This research assistant has been saved. Thank you!

  • @mileygamer7
    @mileygamer7 Год назад +1

    Fabulous tutorial, straight to the point and simple!
    Thankyou!

  • @halofan00
    @halofan00 8 месяцев назад

    What an excellent video, thank you so much!

  • @brunosimonetta7098
    @brunosimonetta7098 Год назад

    just another comment saying THANKS!! legend, making other people's lives easier

  • @johnsonmorakinyo9566
    @johnsonmorakinyo9566 3 месяца назад

    You are exceptionally brilliant. Please how do I reconcile the figures in sales record with bank statement such that uncredited figures in bank statement will be highlighted in sales record

  • @malinivasanth
    @malinivasanth 10 месяцев назад

    Thank you very much. I struggle a lot to find this one.

  • @ahmedsaffah5222
    @ahmedsaffah5222 2 года назад +1

    I salute you, good sir. Saved my life.

    • @EXCELDOERS
      @EXCELDOERS  2 года назад +1

      its my pleasure.. May Allah help us all.

  • @chiecalagui1541
    @chiecalagui1541 2 месяца назад

    Nice bro! Thanks for the help 💪

  • @carvvarc9075
    @carvvarc9075 2 года назад +1

    saved me so much time. my project was doomed if not for you. thanks.

  • @davidkaminski4952
    @davidkaminski4952 2 года назад +2

    Thanks this was easy to understand and did exactly what I needed

  • @xalidperth
    @xalidperth Год назад

    Thanks dear, it will save me a lot of time.

  • @DifficultyGame
    @DifficultyGame Год назад

    actual legend saved me so much time

  • @OldCynthia
    @OldCynthia Год назад

    Yes, took me a while, but it worked! Thank you!

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

    excellent tutorial

  • @divisharma2852
    @divisharma2852 Год назад +1

    Thank you so much for the Trick. Can you please tell what if we want data instead of blank cells. we want that data which is not in our data set 2.

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

    Thanks for this video

  • @md.arifulislam780
    @md.arifulislam780 3 года назад

    Thanks for this video

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

    very effective learning video

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

    Nice one of the best info

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

    Nice tutorial class

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

    Thanks for this video 🙂🙂🙂

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

    Good lesson discussion

  • @CarolMcDonnell-fv1fp
    @CarolMcDonnell-fv1fp Год назад

    You just saved me hours! TY!

  • @md.al-alifsiddiki1620
    @md.al-alifsiddiki1620 3 года назад +1

    Thanks for this Vedio ❤️❤️❤️❤️❤️❤️

  • @ActiveLearningforAll
    @ActiveLearningforAll 4 месяца назад

    Very useful

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

    Wonderful video, very appreciated!

  • @bhagyashreeacharya2419
    @bhagyashreeacharya2419 Год назад

    Thank you sir.

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

    Thank you King

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

    nice teaching

  • @La_i_sap_rwai
    @La_i_sap_rwai 4 месяца назад

    Excellent

  • @edirinokpkpi2581
    @edirinokpkpi2581 2 года назад +1

    Thank you!

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

    Good tutorial

  • @md.arifulislam3616
    @md.arifulislam3616 3 года назад

    very good Tuitorial

  • @deepaksahirwar
    @deepaksahirwar 11 месяцев назад +1

    Awesome

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

    Wow wonderful

  • @md.shamimreza5064
    @md.shamimreza5064 3 года назад +1

    good lessons

  • @basharzatar4389
    @basharzatar4389 2 года назад +1

    Thank you.

  • @annasterk1062
    @annasterk1062 Год назад +1

    Thank you!!!

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

    Nice work

  • @aamirmasood4655
    @aamirmasood4655 2 года назад +1

    Assalam o alaikum, plz advise if you are doing courses in advance excel, thanks,

  • @santoshkumarit_4thyear_263
    @santoshkumarit_4thyear_263 Год назад +3

    Can we sync two list using two columns at same time?(like two columns as key and sync with the other list align them).If anyone know please reply

  • @ahmedalikhan2100
    @ahmedalikhan2100 11 месяцев назад

    Thanks alot.🎉

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

    Thank you so much!

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

    i love you man

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

    Nice job

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

    Thanks a lot

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

    Good guide

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

    Tnks for video

  • @ttzombie
    @ttzombie Год назад

    Perfect !!!

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

    Beautiful

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

    Good job

  • @CarlottaOlivero
    @CarlottaOlivero Год назад

    Thank you! What about data that are in the second sheet but not in the first one? Is there a way to make them appearing with some formula?

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

    Very good

  • @md.arifulislam3616
    @md.arifulislam3616 3 года назад

    thank you

  • @vidsbyme2590
    @vidsbyme2590 8 месяцев назад

    How do we combine rows of information (row a has multiple names some repeating), like you just did, but have the information pulled to another column rather than combine the two? I am looking at a sheet that has multiple rows of the same name but different numbers in each column (column b, c,d etc). I am using mail merge to send out payment reminders but I don't want to have multiple reminders for each payment, would like to have the ability to bull from column a, b, c if they have the same name in column A to c,e,f column.
    john doe(row 1), $xxxx (column b) $xxx (column c)
    john doe (row 2), $xoxoxo (column b), $oyoyoy (column c) I want to move row 2 (because it is the same name), column b & C up to column D & E row 1. I have hundreds of rows some have two or more duplicate names.

  • @Ma.TheresaLasola
    @Ma.TheresaLasola Год назад

    Hi, can you give an example of more than one column referring to the first list, then the same process of sorting to the second list?

    • @EXCELDOERS
      @EXCELDOERS  Год назад

      i ll make video on this in future.

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

    So beautyful

  • @md.abdullahal-mamun5936
    @md.abdullahal-mamun5936 3 года назад

    Thanks

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

    That's FOR this video

  • @cfx9567
    @cfx9567 Год назад

    THANKS

  • @radharadhai-u1f
    @radharadhai-u1f 10 месяцев назад

    I need to find serial number wise same data can you plz help me

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

    Nice❣️❣️❣️❣️

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

    beautiful

  • @sallyyasayan7535
    @sallyyasayan7535 Год назад

    How do you move data in 2 columns at the same time.

  • @Ask-Sen
    @Ask-Sen Год назад

    Cn you please give us the same with multiple criteria to match

  • @md.shayadhossain3551
    @md.shayadhossain3551 3 года назад

    Nice

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

    Nice

  • @marcotjiu6340
    @marcotjiu6340 Год назад

    i know this is to find the similarities about table 1 and table 2, can anyone tell me how do we find the difference between table 1 and 2

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

    thanks

  • @কাজকরিভাই
    @কাজকরিভাই 3 года назад

    Great

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

    Vari joss

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

    nice

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

    Good

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

    Good

  • @MrJahid-yh3ss
    @MrJahid-yh3ss 3 года назад

    nice

  • @md.arifulislam780
    @md.arifulislam780 3 года назад

    Important part of computer

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

    good

  • @flyingdresses6732
    @flyingdresses6732 5 месяцев назад +1

    anyone who knows how to do this exact same process on google sheets?

    • @EXCELDOERS
      @EXCELDOERS  5 месяцев назад

      It will be exactly same as shown in video

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

    good

  • @MdRasel-nc2sz
    @MdRasel-nc2sz 3 года назад

    Goods

  • @zakey9662
    @zakey9662 6 месяцев назад

    Done subscribe

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

    Fine

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

    Wow

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

    ❤️❤️🥰

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

    Wow