Word searching and matching

  • Good morning all


    With thanks to Justin he has added more to my original file that I had envisaged at first.

    What the file is about it is a word finder, some of the words MAY have multiple choices of words available.


    In his code he recognizes a group of letters forming a word, it then colours in the appropriate

    cells and copies the word down to Cell B34 and sorts and counts the number of correct words from the total

    that is listed up in cell B1, which I have listed once all of the are completed.


    On the sheet you will see several coloured cells, as an example the words ( Man, Mankind, Kin, Kind,)

    this type of structure is available in many circumstances.


    What Justin's code only allows us to be able to select the first word of a possible multiple words being selected eg:

    Man, Mankind is now able to be selected.


    Last night Justin recommended that I post the file with an explanation to see if anyone here can come up with

    a solution, He thinks it may some sort of dictionary.


    Finder V1.05jd_PH_Faults.xlsm


    Please text me if any clarifications is needed.


    Regards


    Peter

  • Hi Pete,


    I am working on a solution for this that does not involve a dictionary, just uses the list of words already on the page which I should have thought of in the first place. Although it should be simple I have not got the code to work correctly yet.

    Make sure you include the cross posting at excelforum in your question, it prevents people from wasting their time and keeps you in the good books with the moderators:


    Cross Post is at:

    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    https://www.excelforum.com/exc…matching.html#post5339488


    Regards

    Justin

  • Hi


    I just noticed today that when the code finds a word it transfer that word down to B34,


    On another matter NO Matter what I change cells highlighted in yellow still does not find in both X & Y diections.


    See attached renamed file (Just renamed to keep the original )


    attach=1228387][/attach]


    regards


    Pete


    PS should this go over to Exelforum please

  • Here's a working version! ;)


    You really should not be doing ANY of this via PM. The whole point about a forum is that it's a public database - if important issues are missing, then the record is incomplete. Please keep everything here in this thread. Peter Potholes knows this already - we've been down this road before at the other place.


    If you want to know how it got fixed, see the thread on ExcelForum.

  • Thank you Ali, my fault taking it off line I thought we could put the pertinent updates here and avoid having pages and pages of chit-chat and minor updates to the puzzle.


    I thought I had checked for leading and trailing spaces by retyping in the S in those locations, it must have registered no change when I typed in the S but did register a change to the value when I typed in a different letter (hence other words working but the SAS and SNOOP not).

  • No, nothing should be taken offline (and as Peter knows this already, I am rather cross that he allowed you to do that - he should have known better). Unfortunately, he seems to 'forget' rules and basic forum etiquette when it suits him, despite lots of warnings (both here and at the other place). If he's not careful, he will find himself banned altogether from both this and ExcelForum.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules