+ Reply to Thread
Results 1 to 16 of 16

Macro to pull same consonant words

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,103

    Macro to pull same consonant words

    Find attached data on a1 , going at 34172 words

    Expected results on B and C

    Looking for words with same consonants but different vowel combination
    It should also be able to pull words with two vowels , 5 same consonants ,
    example BANTERS BARNETS BARTONS BRETONS BRISANT BRUNETS BUNTERS BURNETS BURSTEN BURTONS

    The macro should also be able to handle 8 letter words , attached is 7 letter word length
    Attached Files Attached Files
    Last edited by makinmomb; 10-27-2017 at 03:46 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,847

    Re: Macro to pull same consonant words

    Based on the wealth of knowledge you have accumulated over time here with many, many, many similar requests, please share the code that you have tried but is not quite working for you. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,103

    Re: Macro to pull same consonant words

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,103

    Re: Macro to pull same consonant words

    This one by Karedog , requirement to get below results with words on a and b , so
    what i am asking for is not exactly similar

    ALEURON ALEURONE
    TRENAIL TREENAIL
    RATIONS ORATIONS
    STEARIN STEARINE
    ESTRONE OESTRONE
    INERTIA INERTIAE
    GRATINE GRATINEE
    OUTRANG OUTRANGE
    MINUTIA MINUTIAE

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,847

    Re: Macro to pull same consonant words

    And in what way is it not working? What needs tweaking?

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,847

    Re: Macro to pull same consonant words

    There are hundreds of similar threads, not just that one! Come on, try a bit harder, please!!!!

  7. #7
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,103

    Re: Macro to pull same consonant words

    Aligw thank you for pushing , but can you please stop pushing , my time is allocated into
    fighting the bad economic times , so i dont have time at all for this

    The definition of a forum is to help , so i am asking for help , simple

  8. #8
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,103

    Re: Macro to pull same consonant words

    They are people around in here don't mind tackling the case

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,847

    Re: Macro to pull same consonant words

    The definition of a forum is to help , so i am asking for help , simple
    No, actually you are constantly asking for someone else to do it for you. You never show any willingness to try to adapt what you have been shown previously.

    Please remember that those who help here do so voluntarily and of their own goodwill. This is not a paid 'service': members will help you to reach solutions, but they do expect a willingness on your part to meet them halfway. If you do not have the time or the inclination to do this, then you really should be posting your requests in the commercial services section, where you can offer recompense to someone for doing what you have no desire to do yourself.

    They are people around in here don't mind tackling the case
    Yes, and you are relying on their goodwill to get your jobs done for you - again and again and again.
    Last edited by AliGW; 10-27-2017 at 04:36 AM.

  10. #10
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,103

    Re: Macro to pull same consonant words

    I have come up with an idea that should in achieving what i need

    I have got alphgram of the words in this format , assuming
    they are on A1 and B1 need formula on C to pull consonants and D pull
    vowels , thus would expect NTR AND AEIO for and for ETAERIO i would
    expect TR and AEIIO , formula to point on cell b to pull the needful ,
    then i will use sort A to Z and use Highlight Duplicate Values using CF

    NOTAIRE AEINORT
    OTARINE AEINORT
    ETAERIO AEEIORT
    ANEROID ADEINOR
    AILERON AEILNOR
    ALERION AEILNOR

  11. #11
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,103

    Re: Macro to pull same consonant words

    AliGW kindly push the thread to Formulas , thank you

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,847

    Re: Macro to pull same consonant words

    Moved as requested.

  13. #13
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,867

    Re: Macro to pull same consonant words

    my time is allocated into fighting the bad economic times , so i don't have time at all for this

    ... so what is the economic value of your request (and many very similar requests) ??????

  14. #14
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,251

    Re: Macro to pull same consonant words

    I shall say, that I had some time ago similar experience with you makinmomb :-(

    It was "do all for me" approach

    And not trying to learn, but asking again and again the same or VERY similar question.
    Best Regards,

    Kaper

  15. #15
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,103

    Re: Macro to pull same consonant words

    HTML Code: 

  16. #16
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,103

    Re: Macro to pull same consonant words

    Written by some expert , it sorts me out with the below two

    =consonants(B1)
    =vowels(B1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pull words ending with ETTE
    By makinmomb in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 06-20-2017, 08:10 AM
  2. [SOLVED] words with repeat consonant
    By makinmomb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-06-2017, 02:38 AM
  3. VBA – Make a row mandatory by a pull down with different words
    By bees2cute in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-03-2016, 03:47 PM
  4. Pull one word if 1 and two words if 2
    By makinmomb in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2016, 08:06 PM
  5. Pull first 3 words
    By makinmomb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-11-2015, 11:19 PM
  6. [SOLVED] Splitting word list based on syllabic structure, CVC (consonant/vowel/consonant) etc
    By Jay Bee in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-23-2013, 10:36 AM
  7. Replies: 3
    Last Post: 08-14-2013, 10:38 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1