Consulting

Results 1 to 3 of 3

Thread: Compare with two column and return value or highlight match word(s)

  1. #1
    VBAX Newbie
    Joined
    May 2021
    Posts
    1
    Location

    Compare with two column and return value or highlight match word(s)

    Dear Expert,

    I want to compare with two column A and B and find any match word(s).
    This is an apple apple is red
    best friend this is the one
    lets go
    my friend
    cup of water

    For example, base on column A "This is an apple" compare to each cell in column B. any match word will highlight it. or return true/false on column C.
    Please help on this with many thanks!

    chanccl

  2. #2
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,187
    Question is not clear.

  3. #3
    VBAX Expert
    Joined
    Apr 2005
    Posts
    876
    Location
    What is the maximum amount of rows you would have in both Column A and Column B?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •