+ Reply to Thread
Results 1 to 2 of 2

finding the frequency of patterns in data set

  1. #1
    Registered User
    Join Date
    12-02-2014
    Location
    new brunswick, Canada
    MS-Off Ver
    2010
    Posts
    8

    finding the frequency of patterns in data set

    In column A I have a set of cells with either a L, H or blank Value. In column B I have 256 different patterns of possible consecutive L and H combinations to a run of 8. I want to find out how many times each of those pattern combinations show up in column A. The blank values interrupt the pattern.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: finding the frequency of patterns in data set

    I did this by creating an extra column and concatenating the last 8 responses from Column A. Say A1 to A8 in cell B8, A2 to A9 in cell B9 and so on ... ) and then simply use the CountIf formula on each pattern, to count its occurrences in this new column.

    See attached. (I have reduced the data in Column A to 4000 rows to keep the file size small).
    HTH!
    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. 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
  2. Finding Frequency for Data
    By AppleMonster in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-06-2014, 01:20 PM
  3. [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
  4. Finding patterns
    By GaidenFocus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-06-2012, 03:59 PM
  5. Finding Frequency of data
    By kavin in forum Excel General
    Replies: 3
    Last Post: 09-10-2012, 10:41 AM
  6. Finding the Standard Deviation in a Simple Frequency Data Table
    By michaelneedshelp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2009, 03:25 AM
  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