Find specific values out of duplicates


I have data in A:A. This data may contain duplicates. In B:B I have a list with data that will definitely be in A:A.

What I want my code to do is run through my list in B:B individually from top to bottom, and find that exact value in A:A. As soon as it finds a value that is exactly the same it should highlight it and go to the next row in B:B to look for the new value I want to find in A:A. I don’t want it to find all the values that is the same and highlight it. Just One for One.

Example: List A:A —-> apple, lemon, lemon, lime, lemon, apple, pear. List B:B —> lemon, lime, lemon.

Running through B:B it should highlight just one ‘lemon’ in A:A. Then to the next cell’s value and it should highlight ‘lime’. Then the last value in B:B that should be searched is another ‘Lemon’ — It should now highlight only the second ‘lemon’ in A:A, and leave the last lemon un-highlighted.

By: Dewald

388 thoughts on “Find specific values out of duplicates

  1. Roxane

    This very blog is really awesome and also factual. I have chosen many handy stuff out of this source. I ad love to go back again and again. Thanks!

  2. oral surgeon

    I was suggested this web site by my cousin. I am not sure whether this post is written by him as nobody else know such detailed about my problem. You are incredible! Thanks!

  3. LasuNews

    Thanks for some other fantastic post. Where else may anyone get that kind of information in such an ideal method of writing? I have a presentation next week, and I am at the search for such info.

  4. ig

    all the time i used to read smaller articles that as well clear their motive, and that is also happening with this paragraph
    which I am reading at this time.

  5. Hamish

    Pretty section of content. I just stumbled upon your website and in accession capital to assert that
    I get actually enjoyed account your blog posts.

    Any way I will be subscribing to your augment and even I achievement you access consistently fast.

  6. tax accountant uk

    This is very interesting, You are a very skilled blogger. I have joined your rss feed and look forward to seeking more of your wonderful post. Also, I have shared your web site in my social networks!

  7. Kickboxing

    I wanted to thank you for this fantastic write-up, I definitely loved every little bit of it. I ave bookmarked your web site to look at the latest stuff you post.

Comments are closed.