+ Reply to Thread
Results 1 to 18 of 18

Vowel Similars new macro

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

    Vowel Similars new macro

    I have a macro that does the similar , it was done by J T ( John Topley )
    i need a little difference version , look at my sample ,
    i have headers A E I O U ,
    I want the macro to dump the word into the REQUIRED boxes

    Example
    TARTUF(E) DUMP AT column with header E
    TARTUF(I) DUMP AT column with header I
    TARTUF(O) DUMP AT column with header O

    Find file attached
    Attached Files Attached Files

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

    Re: Vowel Similars new macro

    Attached added words from 5001 to 15000 to append above , removed the words of the example since included in above
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,627

    Re: Vowel Similars new macro

    Try
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

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

    Re: Vowel Similars new macro

    KVS this is not correct

  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,366

    Re: Vowel Similars new macro

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JohnTopley; 02-15-2023 at 04:20 AM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

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

    Re: Vowel Similars new macro

    Yes exact , thank you

  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,366

    Re: Vowel Similars new macro

    Miised the "Y" !

    Please Login or Register  to view this content.
    Attached Files Attached Files

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

    Re: Vowel Similars new macro

    Reputation pending , system does not allow to consecutive to one person

  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,366

    Re: Vowel Similars new macro

    Duplicate post removed by JT
    Last edited by JohnTopley; 02-15-2023 at 05:00 AM.

  10. #10
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Vowel Similars new macro

    Not too sure, but my macro yield 1761 result rows while John's yield 106 rows :

    Please Login or Register  to view this content.
    Attached Files Attached Files
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

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

    Re: Vowel Similars new macro

    Sintek J T gives changes at last letter yours gives any position , i was to ask for another thread but you answered before my post of thread , thank you

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

    Re: Vowel Similars new macro

    I thus have 2 good macros within one thread from two professionals here , thank you very much again
    Last edited by makinmomb; 02-16-2023 at 12:31 AM. Reason: to to 2

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

    Re: Vowel Similars new macro

    J T please update the macro with the missed Y column , thank you , when free

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

    Re: Vowel Similars new macro

    Thank you J T , got the Y udated

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

    Re: Vowel Similars new macro

    Karedog small mod required on macro , if it can pour the results alpha mode like how JT pours , words A first b and c and so on

    example from JT presentation

    ABOMASA ABOMASI
    ACADEME ACADEMY
    ACANTHA ACANTHI
    ACCIDIA ACCIDIE
    ACOUCHI ACOUCHY
    AFFABLE AFFABLY
    AGITATE AGITATO
    ALUMINA ALUMINE
    ALVEOLE ALVEOLI
    AMIABLE AMIABLY
    AMORINI AMORINO
    AMOROSA AMOROSO
    ANAGOGE ANAGOGY
    ANESTRA ANESTRI
    ANIMATE ANIMATI ANIMATO
    ANNATTA ANNATTO
    APPALTI APPALTO
    ARCHAEA ARCHAEI
    ARIETTA ARIETTE
    ARRIERE ARRIERO
    ATHLETA ATHLETE
    AUDIBLE AUDIBLY
    AUREOLA AUREOLE
    Last edited by makinmomb; 02-16-2023 at 10:57 PM. Reason: pres

  16. #16
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Vowel Similars new macro

    Quote Originally Posted by makinmomb View Post
    Sintek J T gives changes at last letter yours gives any position , i was to ask for another thread but you answered before my post of thread , thank you
    Sintek ???


    Quote Originally Posted by makinmomb View Post
    Karedog small mod required on macro , if it can pour the results alpha mode like how JT pours , words A first b and c and so on
    Just sort column A by ascending (A to Z) first, before run the macro

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

    Re: Vowel Similars new macro

    Oh okay got you Karedog , thank you

  18. #18
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Vowel Similars new macro

    You are welcome, don't forget to re-marking this thread as solved.

    Regards

+ 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] similars with vowel replaced by consonant rest letters same
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2023, 02:23 AM
  2. [SOLVED] looking for similars with 4 plus answers
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2023, 07:37 AM
  3. [SOLVED] similars with s being replaced with Z
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-08-2023, 02:45 AM
  4. [SOLVED] vowel changing similars by position
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-03-2023, 09:15 AM
  5. [SOLVED] special similars
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-17-2022, 03:27 PM
  6. Similars with vowels end
    By makinmomb in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 05-01-2017, 08:09 AM
  7. Macro to search a string ending with vowel "AEIOUY"
    By kitunga in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-02-2014, 02:37 PM

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