Page 2 of 2 FirstFirst 1 2
Results 11 to 15 of 15

Thread: Compare text in 2 cells and return text in another cell

  1. #11
    Seeker Kolyu's Avatar
    Join Date
    Oct 2018
    Location
    Sofia, Bulgaria
    Posts
    10
    Articles
    0
    Excel Version
    2007, 2010, 2013, 2016


    Register for a FREE account, and/
    or Log in to avoid these ads!

    So let's see what version of Excel Steevg has and discuss further.

    It is not impossible to solve this without PQ, ,but it would be much, much harder

  2. #12
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,239
    Articles
    0
    Excel Version
    Office 365 Subscription
    He has written 2011 in his profile - that's a Mac version, not a Windows version.

    https://thesmartmethod.com/excel-versions-explained/
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #13
    Seeker Steevg's Avatar
    Join Date
    Jul 2019
    Posts
    6
    Articles
    0
    Excel Version
    2011
    Correct 2011 on my home iMac - but I'm also to run it on 16.23 at work - and I'm a Mac OS X (10.14.4) user.

    AliGW - I understand this was a difficult task to accomplish - hence why I reached out to this forum, as it's beyond my understanding of what excel can and can't do.

    However, you have hit the nail on the head - specifically there are words in one cell which I'd "like" to compare with words in the other cell. They will all have spaces as delimiters (ie: no comma's etc), and there may be several words in the cell ( 3 or 4, & potentially a short number sequence - 1234 for example).

    The sample sheet looks like it does the job nicely.

    So if PQ is not available for the Mac version, is there another option to achieve similar results on either of the Mac's I use Kolyu?

  4. #14
    Seeker Kolyu's Avatar
    Join Date
    Oct 2018
    Location
    Sofia, Bulgaria
    Posts
    10
    Articles
    0
    Excel Version
    2007, 2010, 2013, 2016
    From my experience, Steve, I have learned that it is only impossible to make pan cakes for breakfast with Excel.

    However, possible does not mean easy or totally automated.

    check my proposed solution without PQ in attached file. In summary:

    1. Apply Text-to-columns for Input and Input2 using space as a delimiter (manual operation)
    2. Populate formulas that check whether each string in Input1 is met in Input 2 and vice versa (manual copy/paste). If yes - returns TRUE, otherwise - FALSE
    3. Check with formula for each row whether number of TRUEs > 0

    Could be automated with some macro but I have never written VBA for MAC and I know there are some specifics, so I'm afraid to propose VBA solution.
    Attached Files Attached Files

  5. #15
    Seeker Steevg's Avatar
    Join Date
    Jul 2019
    Posts
    6
    Articles
    0
    Excel Version
    2011
    Kolyu,

    Many thanks, I'll give it a go and see if it's feasible - I have over 4,500 lines to sort, many with up to 7 "words"/"digits" per cell, so will be interesting to see if this works as required. If it does, I may try to use an Applescript to carry out the functions automatically rather than a VBA script.

    I'll post back here with the results in a few days.

    Appreciate yours and AliGW's help on this tricky situation.

Page 2 of 2 FirstFirst 1 2

Posting Permissions

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