+ Reply to Thread
Results 1 to 10 of 10

Sort LIST by 3 vowels and 4 vowels and 5 vowels

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

    Sort LIST by 3 vowels and 4 vowels and 5 vowels

    Find attached list of words

    Need 3 run buttons

    run 3
    run 4
    run 5

    run three to give me letters with 3 vowels , delete the rest of the words
    run three to give me letters with 4 vowels , delete the rest of the words
    run three to give me letters with 5 vowels , delete the rest of the words

    Say if i did the below manually for giving me a list of words for 3 vowels

    NEEDLIER , I would do shift cells up
    ENSEALED , I would do shift cells up
    SELENIDE , I would do shift cells up
    RELENTED , would keep
    NEEDLERS , would keep
    Manually going word by word would be long

    File attached
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,364

    Re: Sort LIST by 3 vowels and 4 vowels and 5 vowels

    You appear to be removing DLN also ???

    run three to give me letters with 3 vowels , delete the rest of the words
    do you mean ..

    "run three to give me WORDS with 3 vowels , delete the rest of the word"

    and where is complete list of words as your sample are WORDS with 2 vowels and is it the output required??
    Last edited by JohnTopley; 01-29-2024 at 02:15 PM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,364

    Re: Sort LIST by 3 vowels and 4 vowels and 5 vowels

    Guessing

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JohnTopley; 01-29-2024 at 05:13 PM.

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

    Re: Sort LIST by 3 vowels and 4 vowels and 5 vowels

    JT you got me wrong , no need to paste dictionary , within the same results sheet I have given i want it to do

    run three to give me letters with 3 vowels , delete the rest of the words
    run three to give me letters with 4 vowels , delete the rest of the words
    run three to give me letters with 5 vowels , delete the rest of the words

    Even if there is no no run button will do ALT F8 to run in which i should find i will find 3 options to choose , 3 in 1 macro

    Macro to trim away all words except what i asked for e.g. 3 vowels , ignore run button there is no place to place it this time without
    RUN button so that u can understand what i need , search range a2:r2 downwards and do the needy removals of what i dont need

    If u can pour at sheet 2 , words of sheet 1 in the same layout for words with 3 vowels
    If u can pour at sheet 3 , words of sheet 1 in the same layout for words with 4 vowels
    If u can pour at sheet 3 , words of sheet 1 in the same layout for words with 4 vowels
    ( This way you will understand me closer )

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,364

    Re: Sort LIST by 3 vowels and 4 vowels and 5 vowels

    No idea what you want as the sheet you initially posted only had words with 2 vowels. Wrong file ? - see post #2

    so I will leave it others.
    Last edited by JohnTopley; 01-30-2024 at 05:18 AM.

  6. #6
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,617

    Re: Sort LIST by 3 vowels and 4 vowels and 5 vowels

    Find attached it picked the wrong file looks like , see that RUN 3 and RUN4 and RUN5

    It is your own macro with that add on which i did not wanna continue in the same thread

    My apologies with the wrong file upload not sure how it picked thaT

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,364

    Re: Sort LIST by 3 vowels and 4 vowels and 5 vowels

    No sample output: and as I said previously, over to others.

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

    Re: Sort LIST by 3 vowels and 4 vowels and 5 vowels

    when u run hit 3 vowels , then say from below , DLN column , then go to the next DLR and so on

    DIGONAL
    DOLINAS
    LADINOS
    LIANOID
    LOADING
    MONDIAL
    NODICAL
    ORDINAL

    Then it will remain

    DIGONAL
    DOLINAS
    LADINOS
    LIANOID ( REMOVE this line so this wont be there at has 4 vowels )
    LOADING
    MONDIAL
    NODICAL
    ORDINAL
    Last edited by makinmomb; 01-30-2024 at 05:47 AM. Reason: gram

  9. #9
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,364

    Re: Sort LIST by 3 vowels and 4 vowels and 5 vowels

    see attached

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

    Re: Sort LIST by 3 vowels and 4 vowels and 5 vowels

    Yes this one JT , working exactly as i need . thread closed

    Thank you again

    Reputation pending as I have given u Repu last does not accept second time unless I have given Repu to someone else in between

+ 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. [SOLVED] count vowels
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-24-2023, 06:53 AM
  2. [SOLVED] COUNT vowels
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-20-2022, 01:42 AM
  3. [SOLVED] similar by vowels
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-21-2022, 12:08 PM
  4. similar by vowels x 3
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2022, 03:39 AM
  5. [SOLVED] Vowels counter
    By makinmomb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-25-2017, 02:29 AM
  6. Similars with vowels end
    By makinmomb in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 05-01-2017, 08:09 AM
  7. How to do those lines on top of vowels?
    By stars in forum Excel General
    Replies: 1
    Last Post: 06-15-2006, 03:10 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