+ Reply to Thread
Results 1 to 5 of 5

EARTHPEA HEARTPEA such pattern SEARCH

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

    EARTHPEA HEARTPEA such pattern SEARCH

    EARTHPEA HEARTPEA

    I am looking for such pattern words

    Where the last 3 letters are same in this example PEA then the 5th lettter coming to the 1st , the H of EARTHPEA came infront to form a word called HEARTPEA

    Fine file attached file with dictionary at 5ooo rows , the macro needs to go dig into 55555 rows to pour results

    Macro Speed not important provided it pours results

    Find File attached
    Attached Files Attached Files
    Last edited by makinmomb; 03-30-2023 at 01:22 PM.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: EARTHPEA HEARTPEA such pattern SEARCH

    Once these common words are determined, what do you want to do with them?

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

    Re: EARTHPEA HEARTPEA such pattern SEARCH

    the results i have shown in sample paste in pairs at C and D

  4. #4
    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: EARTHPEA HEARTPEA such pattern SEARCH

    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.

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

    Re: EARTHPEA HEARTPEA such pattern SEARCH

    Yes John , exactly what i needed , thank you again

+ 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] Rotation Pattern based on the Pattern String for scheduling tasks
    By qadeerume in forum Excel General
    Replies: 8
    Last Post: 08-11-2020, 11:49 PM
  2. Replies: 4
    Last Post: 01-27-2020, 04:40 AM
  3. Replies: 7
    Last Post: 08-27-2019, 08:37 AM
  4. Continuing a pattern on autofil without pattern re-starting
    By jakeyoung111 in forum Excel General
    Replies: 4
    Last Post: 06-22-2016, 11:11 AM
  5. [SOLVED] Lookup and return rows based on pattern start and pattern end
    By JDI in forum Excel General
    Replies: 18
    Last Post: 11-16-2014, 11:44 PM
  6. Copy down hypertext cell range pattern & cell reference formula pattern
    By Underexcelling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2014, 03:23 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