Results 1 to 15 of 15

finding patterns in a range of cells

Threaded View

  1. #1
    Registered User
    Join Date
    01-03-2013
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    35

    finding patterns in a range of cells

    Attached, please find excel file to show data.
    I have a variety of patterns in cells B:G as follows:
    0 1 0 1 0 0
    0 0 0 0 0 1
    1 0 0 0 1 1
    0 1 0 1 0 0
    etc..
    Need help with a vba to find patterns and list them separately in new cells (L:Q) and their frequencies, as indicated in the file.
    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding patterns
    By GaidenFocus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-06-2012, 03:59 PM
  2. Replies: 3
    Last Post: 04-01-2012, 05:37 AM
  3. Macro to search for patterns in a range of dates
    By bsweet0us in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2011, 10:49 PM
  4. Finding same patterns in groupings of cells
    By modoud in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2007, 01:19 PM
  5. Patterns in cells won't print
    By Gabrielle in forum Excel General
    Replies: 2
    Last Post: 04-21-2006, 09:25 AM

Tags for this Thread

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