+ Reply to Thread
Results 1 to 3 of 3

Finding patterns in column

  1. #1
    Registered User
    Join Date
    08-20-2019
    Location
    Chicago
    MS-Off Ver
    10
    Posts
    2

    Finding patterns in column

    I have a column with 1,2 & 3’s and I am trying to find a pattern that will act as a sell trigger. I need four separate formulas for four different triggers to analyze.

    #1- any pattern with 2 of the same and any 3rd, i.e. YXX, XYX, XXY

    #2 same as #1 but looking back where Y has not been in the previous 3 rows prior to the trigger.

    #3 Specific pattern any number 1st and the same number in 2nd and third position i.e. YXX

    #4 same as #4 but looking back where Y has not been in the previous 3 rows prior to the trigger.

    Any help with this would be great

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Finding patterns in column

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    08-20-2019
    Location
    Chicago
    MS-Off Ver
    10
    Posts
    2

    Re: Finding patterns in column

    Trying to upload sample I hope this worked
    Attached Files Attached Files

+ 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. help finding patterns in columns?
    By HMexcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2019, 01:54 PM
  2. [SOLVED] Excel finding patterns across data range
    By hazzaska in forum Excel General
    Replies: 5
    Last Post: 04-21-2017, 02:42 AM
  3. finding the frequency of patterns in data set
    By fatterthanelvis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2016, 08:28 AM
  4. Finding Patterns in String of Text in One Column
    By HDTV in forum Excel General
    Replies: 3
    Last Post: 10-08-2014, 08:03 AM
  5. [SOLVED] finding patterns in a range of cells
    By shart2k12 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-27-2013, 11:07 AM
  6. Finding patterns
    By GaidenFocus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-06-2012, 03:59 PM
  7. Finding same patterns in groupings of cells
    By modoud in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2007, 01:19 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