+ Reply to Thread
Results 1 to 6 of 6

Excel finding patterns across data range

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Stoke, England
    MS-Off Ver
    Excel 2003
    Posts
    59

    Excel finding patterns across data range

    Hi

    I have a sheet with 6 rows of data per entry and a column indicating if the data is positive or negative, ((1 for positive) can excel analyse the numbers across the rows to find a pattern if indicated as positive?


    Thanks for any help offered
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,821

    Re: Excel finding patterns across data range

    Need more information - what do you mean by a pattern, show some expected results, etc.
    Glenn



  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,599

    Re: Excel finding patterns across data range

    And more specifically .. how do you determine a row is either positive or negative ? There doesn't seem to be a correlation with the numbers ???

  4. #4
    Registered User
    Join Date
    04-11-2012
    Location
    Stoke, England
    MS-Off Ver
    Excel 2003
    Posts
    59

    Re: Excel finding patterns across data range

    I am trying to see what numbers from what columns form a pattern when i deem it a positive result by entering 1 into a row in column h

    For example if the result is positive does the number 3 appear often in column b or the number 2 in column c etc

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,599

    Re: Excel finding patterns across data range

    Paste this into a Routine Module, activate from a Command Button on Sheet 1:

    Please Login or Register  to view this content.
    Move your Positve/Negative column to Col M. This will prevent the code from considering the 1's and 0's in that column as part of the pattern.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    04-11-2012
    Location
    Stoke, England
    MS-Off Ver
    Excel 2003
    Posts
    59

    Re: Excel finding patterns across data range

    Thanks for your help i will give it a go.

    H

+ 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. Replies: 2
    Last Post: 10-07-2016, 10:02 AM
  2. 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
  3. Macro For Advance Math Sequences In Finding Number Patterns or Missiing Numbers
    By Daddy007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2016, 06:44 PM
  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