I wish I found you months ago. Although I don't need to do this often yet for when I do, it takes me quite a while instead of a few seconds. Many thanks :-)
I have two columns. In Column 2 (the longer list of numbers), I want to highlight the numbers that are in Column 1. I do NOT want to highlight the duplicates WITHIN Column 2. Is this possible?
How do you compare two columns? I have searched and searched. I have two columns of numbers and want to have one cell at the top that simply will tell me if ANY records in column A exist in Column B.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Thank you for posting this!! Much appreciated. You just saved me a lot of work.
Hi, i am a CPA in progress and this helped me a lot. Gr from Amsterdam
thanks for this. As much as I like countif/s sumif/s functions its very resource heavy. For big data sets it causes excel to lag and freeze
muchas gracias man ... i was looking for this ... god bless you!
I wish I found you months ago. Although I don't need to do this often yet for when I do, it takes me quite a while instead of a few seconds. Many thanks :-)
I got the answer I needed in around 30 seconds. Thank you!
This video was very helpful. Thanks
You're welcome! You're invited to get free Excel tips straight to your inbox, sign up here www.excel-university.com/subscribe/
This was so helpful
Thank you so much i was able to complete a comparison task in less than five minutes :)
Thank you for your help!
I have two columns. In Column 2 (the longer list of numbers), I want to highlight the numbers that are in Column 1. I do NOT want to highlight the duplicates WITHIN Column 2. Is this possible?
very nice,
There is also a function called EXACT
How do you compare two columns? I have searched and searched. I have two columns of numbers and want to have one cell at the top that simply will tell me if ANY records in column A exist in Column B.