Excel - Compare Two Worksheets for Matches or Duplicates with No Unique IDs Tutorial - Part 3

[@larisselausingco7007]

THANK YOU SO MUCH FOR THIS VIDEO!!! REALLY HELPED SORT OUT 4,000 APPLICATIONS BECAUSE OF THIS!!! KUDOS!!!

[@colinferrington4151]

This video is excellent. After looking at other supposed solutions to the problem and wasting quite a bit of time, implementing this method on my own spreadsheets was reasonably straightforward and best of all, it worked! Thank you for sharing!

[@thaihuyhai3331]

Thank for your video, it is great. Can you help to attach the excell file so that we can load then practise as what you instruct. Thank you

[@jeanbackla9139]

Im an excel noob and your vid helped me a lot. Thanks so much!!

[@teeheeleelee]

Thank you *so* much for this video! I definitely did not want to spend my day manually matching up 2,000+ records across different spreadsheets :)

[@ExcelGoogleSheets]

Glad it helped!

[@yeoph5002]

Great ideas with many useful tips! I tried to follow your video but received "DataFormat.Error: We couldn't convert to Number"at time 8:18 of your video. Is there any way to solve this?

[@undercoveranget1415]

Is there anyway to use function (If) to code with a 1 being a match found or 0 no match found for that?

[@vatsalthebest]

Great !!! But is there any limitations of match function in terms of the number of characters it can search at a time???

[@kalpdalal6534]

Thanks. This helped me!

[@expert1989123]

Very useful video, keep making them. :)

[@irenenguyen2085]

Hey, TY so much for these videos. You are teaching me so much. Is there a way to compare two sheets if the info in the cell is not entered exactly the same on each sheet? For example, sheet1 A2 is entered as John B. Smith and sheet2 A2 is entered as John Smith. Is there a way that I can have it alert as a potential match?

[@ExcelGoogleSheets]

kzbin.info/www/bejne/rKKcaZtve6Zlqqs kzbin.info/www/bejne/laDKhmCri6t7r68

[@shrekikiki]

Great video. which of those method will work with Macro recording?

[@ExcelGoogleSheets]

All of them should.

[@angogar]

Hi. we play with the workmates who tip the most rows on the Europatipset (Sweden; series of 13 matches). And now I have created a spreadsheet about who has how many right. Everything works until we have some with the same number right. I have a formula that finds the most number right and writes in the cell next to the winner's name. But if they are two or more? how to write all the names that are right?

[@LotfyKozman]

Great efforts, thanks

[@heinsenberga86]

Thanks a lot!

[@dinahany233]

thank u

[@lazalazarevic6192]

great :)

[@SharifulIslam-fp4yk]

*If your data are arranged among multiple columns in Microsoft Excel and you want to find the cell or data values are common among all these columns using VBA within moment of just a click then you can check-* kzbin.info/www/bejne/qorZe2xqZ76th7c

[@BobBacheler]

Was useful until about 4 minutes in when he just went zoom and could no longer be followed.

[@thew9gamer]

There needs to be an easier way...