+ Reply to Thread
Results 1 to 5 of 5

2 consonants changing with position summary

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

    2 consonants changing with position summary

    Please

    Look at this

    I am looking for such pattern

    SYCONIA SYNOVIA

    Where 2 consonants changes at above example SYC SYN consonant changed at letter position 3
    Where 2 consonants changes at above example ONIA OVIA consonant changed at letter position 5

    Then summarise at column K see i have written 35 means 3rd letter changed by a consonant and 5th letter
    changed by a consonant too

    Find File attached

    Thank you with dictionary of 1o,ooo plus rows to follow
    Attached Files Attached Files
    Last edited by makinmomb; 03-28-2024 at 11:23 AM.

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

    Re: 2 consonants changing with position summary

    Find attached dictionary with 5ooo words , if macro works i will test it on the 33ooo rows dictionary

    Thank you again
    Attached Files Attached Files

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

    Re: 2 consonants changing with position summary

    Please Login or Register  to view this content.
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

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

    Re: 2 consonants changing with position summary

    JT this sorts me exactly the way i needed it poured the following 65 results at flash 1 seconds

    ADRATES ADWARES
    ARROWED RAZORED
    ASSURES SARUSES
    BEMIRED BERIMED
    BEMIRES BERIMES
    BETIMED BEMIXED
    BETIMES BEMIXES
    CALIVER CAVILER
    CAMASES CANAPES
    CERUSES CESURES
    CHLORIC CHROMIC
    DECILES DELICES
    DEFACED DECALED
    DELETED DEVELED
    DEPONED DENOTED
    DEVOTED DETOXED
    DEVOTES DETOXES
    DICHTED DITCHED
    DOGATES DOTAGES
    ESSAYED ESTATED
    ESSENCE SENESCE
    EXCEPTS EXPECTS
    FECHTER FETCHER
    HABITED HAMBLED
    HOLSTER HOSTLER
    HOVERED HOSEYED
    INCESTS INSECTS
    INSIDES INDITES
    JAVELLE JAMESES
    KARAKAS KAMALAS
    KENOSES KETONES
    KENOTIC KETONIC
    KINARAS KIRANAS
    LETCHES LECHWES
    MANGLED MALGRED
    METAYER SESAMES
    MILTZES MIZZLES
    MUNITED MUTINED
    MUNITES MUTINES
    MUSCLED MULCTED
    PATAKAS PALATAL
    PAVANES PANAXES
    PITARAS PIRAYAS
    REGIMES REMIGES
    RELIVED REVILED
    RELIVER REVILER
    RELIVES REVILES
    RENESTS RESENTS
    RETAPES REPAVES
    RETIMED REMIXED
    REVISES RESIZES
    REVOKES SEKOSES
    ROLLWAY ROYALLY
    ROWOVER SOROSES
    TACKLED TALCKED
    TAMARAS TARAMAS
    UNCAPED UNPACED
    UNCARED UNRACED
    UNMATED UNTAMED
    UNNESTS UNTENTS
    UNNOTED UNTONED
    UNSIZED UNWIVED
    UNTIMED UNMIXED
    UNWAGED UNGAZED
    ZIZANIA VIVARIA

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

    Re: 2 consonants changing with position summary

    Repu on this thread is pending , other pendings i will keep clear if i have given others repu

    Thank you again JT

+ 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] vowel changing similars by position
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-03-2023, 09:15 AM
  2. [SOLVED] Pull consonants after removing consonants on cell A1
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-27-2022, 12:54 PM
  3. Replies: 1
    Last Post: 10-25-2021, 10:53 AM
  4. [SOLVED] Are first 2 letter consonants ?
    By makinmomb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-10-2017, 04:24 AM
  5. Replies: 2
    Last Post: 04-15-2014, 05:42 AM
  6. Sorting without changing the position
    By firdaus.mokhtar89 in forum Excel General
    Replies: 8
    Last Post: 10-21-2013, 02:06 AM
  7. Excel 2007 : Changing the position of names
    By sushil10s in forum Excel General
    Replies: 1
    Last Post: 01-23-2012, 11:48 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