Excel - Find Matches Between Two Sheets , Automated - Tutorial - Part 2

[@yourface2616]

This was my first introduction to power query. I’ve seen it before and heard about it. Your part one made an easy transition to part 2, where it gets good. Thank you

[@sangeetabalchandani5128]

It’s an extremely underrated channel can’t believe this. You have helped me a lot. Thank you for all you do! 🙏🏼

[@mrabalone3492]

aaaaaaaaaaaaaa!!!!!!! this is what i am looking for !!! have been searching for few hours! Thank a lot SIR!

[@leewarps]

Just what I was looking for. Thanks a ton.

[@Danilo111]

Excellent video, I'm surprised that so few people have seen it. Thank you

[@alangeorge672]

Very cool idea

[@excelworx8712]

Just brilliant!

[@blythecarlos4746]

What if I just need to highlight the matched row not create a table?

[@excelworx8712]

Then you dont need to go any far. Just use conditional formatting

[@natelyons8327]

Excellent work sir!

[@19ramsheed]

Awsome, you saved my day

[@ExcelGoogleSheets]

Glad to hear it!

[@carlosgaspar4207]

Good video, but I have not Power Query. Will be possibility show another way to do that? Thank you

[@TheReluctantCoder]

At 14:11, Mine doesnt have a merge option! :( is there an alternative?

[@bradgutzki7562]

thank you!!

[@hanrealistic]

how about paste a list of data on a sheet to compare all of the data at once with the data on another sheet?

[@Moshpearl]

This is brilliant. But does this work for datas that has updated information. For example big sheets with username, address, phone number. Sometimes there will be new users, sometimes there will be phone number updated or sometimes there will be updated address. My question is: In this method shown in video you can map the data if all the values are same and it pulls data with same values I guess and the missing rows, But will this work for any updated values? If not could you suggest which method helps for regular monthly updates for big excel files.

[@ExcelGoogleSheets]

Yes, you would just need to click the refresh button.

[@OMORFIAorg]

Hello, please tell me how to find duplicates in two different FILES in google sheets and highlight them? Thank you.

[@krishnaa581]

Hi, Thank you so much for this video. Very helpful! I was fiddling with vlook up and IF/error condition for a week to merge data and this one turned out to be piece of cake :) Only thing not clear is.. when there is data over 5k between two work sheets, the results showing only 33 lines for merging and rest come as "null". I am unable to understand or overcome this.. it would be really helpful if you can let me know how to use the technique for lines over 5k lines in an excel across multiple tabs. Thank you!

[@ExcelGoogleSheets]

It seems like your values in two worksheets don't really match.

[@ব্ৰহ্মপুত্ৰ]

Excellent tutorial professor! Just one question, is it possible to do this for more than 2 tables?

[@olayemiowoputi8362]

Hello, what if my tables have different headers but with unique texts in both tables. How do i match them. kind regards

[@ExcelGoogleSheets]

Doesn't have to have the same header. Just click on the column from each table that has to match.

[@olayemiowoputi8362]

@@ExcelGoogleSheets Thank you for your response. However, after merging my table takes longer time to load the null entities/identify the data that match. I habe never succeeded in all my trial. Please what could be wrong?

[@jarrettd1231]

THANK YOUUUUUUU !!!!!!!!!

[@ChrisTingom]

Thanks!!

[@lotlotdacome2731]

Hi, this was so helpful! Question - can you apply the same concept to 2 different excel spreadsheet files?

[@ExcelGoogleSheets]

yes

[@harriettdearmond2306]

Do you have this for Google Sheets instead of Excel?

[@ExcelGoogleSheets]

Part 1 of this Excel tutorial can be used in Google Sheets. You won't be able to do Power Query stuff in Google Sheets though.

[@nikhilgaw07]

How to match two cells with other two cells. e.g. 1a with 1a, 2b with 2b & so on.. I tried to use some logic but it failed

[@lazalazarevic6192]

I love PQ