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!
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?
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?
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?
*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-* ruclips.net/video/tYvJ942YzQU/видео.html
THANK YOU SO MUCH FOR THIS VIDEO!!! REALLY HELPED SORT OUT 4,000 APPLICATIONS BECAUSE OF THIS!!! KUDOS!!!
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!
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 :)
Glad it helped!
Im an excel noob and your vid helped me a lot. Thanks so much!!
Is there anyway to use function (If) to code with a 1 being a match found or 0 no match found for that?
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
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?
Great !!! But is there any limitations of match function in terms of the number of characters it can search at a time???
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?
Very useful video, keep making them. :)
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?
ruclips.net/video/vq98h9FA2tI/видео.html
ruclips.net/video/_ogU-uVFHyM/видео.html
Thanks. This helped me!
Great video. which of those method will work with Macro recording?
All of them should.
Great efforts, thanks
Thanks a lot!
thank u
great :)
There needs to be an easier way...
*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-* ruclips.net/video/tYvJ942YzQU/видео.html
Was useful until about 4 minutes in when he just went zoom and could no longer be followed.