Hello
Thank you in advance for any help. I want to compare column A in sheet one to column b in sheet two (values are alphanumeric ) and highlight the duplicates found in sheet 2. To be more precise I would like to take column A in sheet one and scan all of column b in sheet 2 but this value could also be found in a sentence in column b of sheet 2. My end goal is to highlight any values from column a in sheet one found in column b of sheet 2.
Cheers
Last edited by Habs21; 09-24-2014 at 06:49 PM.
Post a sample data set.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Hello,
Attached you will find the excel document i am trying to find duplicates in. i would like to compare Column A in sheet 1 to column B in sheet 2 and highlight any duplicates found in sheet 2. Please note that column B in sheet 2 contains sentences i need to search for any of the key words from column A in sheet 1. Thank you for your assistance.
Cheers,
Last edited by Habs21; 09-10-2014 at 10:26 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks