+ Reply to Thread
Results 1 to 5 of 5

Identifying The Pattern

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    461

    Identifying The Pattern

    Hi All,

    We have framed the email pattern for the first name and last name. We need the formula to identify which of these pattern we had framed. Which is in H Column highlighted in blue color. I have attached the same file.

    Thank You
    Attached Files Attached Files
    Last edited by sathishkm; 03-02-2022 at 06:02 AM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Identifying The Pattern

    Expecting 35 Combinations in formula?

    Please Login or Register  to view this content.
    UDF will be the right approach.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    461

    Re: Identifying The Pattern

    How can we do UDF ?

  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
    27,998

    Re: Identifying The Pattern

    Please Login or Register  to view this content.
    =Epattern(A2:G2)

    And thanks to Sixthsense: I used his table to help generate the code.
    Attached Files Attached Files
    Last edited by JohnTopley; 03-02-2022 at 11:03 AM.
    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
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    461

    Re: Identifying The Pattern

    This excel macro is not able to get the result.

    Thanks

+ 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. Identifying the pattern
    By sathishkm in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-08-2019, 07:25 PM
  4. Replies: 7
    Last Post: 08-27-2019, 08:37 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. Loop through rows identifying a positive/negative pattern and return value
    By nguyeda in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2013, 04:15 PM
  7. Using the .Pattern Method for identifying Strings
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2013, 07:20 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