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

The video highly recommended to students, officers and Business people as well specially those who works on different set of data.
After watching this video you will be able to do following:
1) How to two sort two set of data in Microsoft Excel
2) How to synchronize two list of data in Microsoft Excel
3) How to play smartly with Vlookup formula?
4) How to handle large set of data in Microsoft Excel?
To get important updates and links, please subscribe to our newsletter:
www.exceldoers.com/newsletter/
our website: www.exceldoers.com
our facebook page: exceldoers
Our Channel URLs:
www.excelforfre...
#ExcelSorting #DataSort #Sorting #Dataset #SynchronizeData #PlaywithData #Vlookup #Sorting #acendingorder #excelsort

[@Boogle_123]

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

[@russellwordsworth8423]

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

[@sowmyad9873]

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

[@deepamjyotidas3755]

Me too.

[@Stevo1361]

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]

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
[e-mail]

[@bkingdom4403]

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!:)

[@sharanyaissac5005]

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

[@BethGardnerPPS]

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

[@thecolossalworld]

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

[@jacksondo55]

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

[@Damien1_1]

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]

Thank u. Explore our channel for more great videos

[@mileygamer7]

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

[@pathansami]

This was an extremely helpful video. Thank you!

[@aftabalamusmani2020]

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

[@EXCELDOERS]

Great. Share with others

[@chiecalagui1541]

Nice bro! Thanks for the help 💪

[@feitw]

This research assistant has been saved. Thank you!

[@Engel990]

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

[@EXCELDOERS]

Enjoy.. explore more our channel and share with others

[@davidkaminski4952]

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

[@brunosimonetta7098]

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

[@ahmedsaffah5222]

I salute you, good sir. Saved my life.

[@EXCELDOERS]

its my pleasure.. May Allah help us all.

[@carvvarc9075]

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

[@DifficultyGame]

actual legend saved me so much time

[@halofan00]

What an excellent video, thank you so much!

[@xalidperth]

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

[@OldCynthia]

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

[@johnsonmorakinyo9566]

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

[@CarolMcDonnell-fv1fp]

You just saved me hours! TY!

[@ubidashimu9415]

Nice one of the best info

[@PastaSenpai]

Wonderful video, very appreciated!

[@irenatonney8436]

very effective learning video

[@isanurhossn1904]

Thanks for this video 🙂🙂🙂

[@masumbillah2665]

Thanks for this video

[@md.al-alifsiddiki1620]

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

[@MorrissonF]

Thank you!

[@emonshariyar4155]

Nice tutorial class

[@divisharma2852]

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.

[@malinivasanth]

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

[@deepaksahirwar]

Awesome

[@ahmedalikhan2100]

Thanks alot.🎉

[@ayaanahmad9646]

excellent tutorial

[@La_i_sap_rwai]

Excellent

[@ashik2940]

Good lesson discussion

[@ActiveLearningforAll]

Very useful

[@tarequrerahman768]

nice teaching

[@palashhossain2989]

Good tutorial

[@basharzatar4389]

Thank you.

[@md.arifulislam780]

Thanks for this video

[@titohasan4644]

Wow wonderful

[@md.arifulislam3616]

very good Tuitorial

[@sebastienk7915]

i love you man

[@santoshkumarit_4thyear_263]

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

[@annasterk1062]

Thank you!!!

[@EXCELDOERS]

Welcome!

[@shamolykhatun564]

Nice work

[@md.shamimreza5064]

good lessons

[@maxxwellio]

Thank you King

[@thezapabelic6629]

Thank you so much!

[@bhagyashreeacharya2419]

Thank you sir.

[@monjurhasan1233]

Tnks for video

[@aamirmasood4655]

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

[@ttzombie]

Perfect !!!

[@mstsima6422]

Beautiful

[@akibivas]

Thanks a lot

[@bmsaddamhossain3262]

Nice job

[@middleclassbiker4150]

Good guide

[@md.abdullahal-mamun5936]

Thanks

[@zahidulislam2458]

So beautyful

[@cfx9567]

THANKS

[@sihirislam9142]

Good job

[@rsanupom3061]

Vari joss

[@mdrabbykhan3755]

Nice❣️❣️❣️❣️

[@jahidhassan3855]

Very good

[@mdmuradhassan6205]

That's FOR this video

[@sorouarhosen2855]

thanks

[@md.arifulislam3616]

thank you

[@altaf2khan150]

Nice

[@user-rz4yw1vj2k]

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

[@md.shayadhossain3551]

Nice

[@vidsbyme2590]

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.

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

[@EXCELDOERS]

Reach me at [phone]

[@aktarulislam8830]

Good

[@tajuhossain3021]

beautiful

[@user-ku6se1ry1k]

Great

[@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]

i ll make video on this in future.

[@sallyyasayan7535]

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

[@MrJahid-yh3ss]

nice

[@erecharge5831]

Good

[@shagorhassan4221]

Wow

[@MdRasel-nc2sz]

Goods

[@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

[@Ask-Sen]

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

[@rezarabbi7419]

nice

[@md.arifulislam780]

Important part of computer

[@sahedahmed1717]

Wow

[@mdashikurrahman9942]

good

[@mkhumayunkabir1272]

good

[@mdnazmulislam3313]

Fine

[@zakey9662]

Done subscribe

[@mdrajibhossain685]

❤️❤️🥰

[@sagorhossain1774]

wow

[@flyingdresses6732]

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

[@EXCELDOERS]

It will be exactly same as shown in video

[@atiq9754]

BRO IF YOU WERE IN KENYA I COULD HAVE GIVEN YOU TWO WIFES SIMULTANEOUSLY WITH THEIR MAIDS .LONG LIVE