+ Reply to Thread
Results 1 to 2 of 2

Finding same patterns in groupings of cells

  1. #1
    Registered User
    Join Date
    07-19-2007
    Location
    San Francisco
    Posts
    1

    Finding same patterns in groupings of cells

    I have a worksheet (and will have many in the future) having various data. In a particular set of columns there are 1, 2 or 3 characters per cell. In other cells in the sheet there are characters and numbers. I only want to search a particular group of cells for a pattern. Below shows a particular set of rows and columns. I want to be able to identify the pattern in row 1 (X Y L H B) and find all occurances of this (the example shows row 4). There will be mulitiple occurances.

    Given:
    Cells A B C D E F ETC
    1 X Y L H B
    2 X C L B H LH
    3 B L HL B X XH
    4 X Y L H B
    ETC

    I want to find all the occurances of X Y L H B (Row 1) through the sheet.

    Please help me understand how to do this. Thank you and
    Be Well...
    Grateful

  2. #2
    Registered User
    Join Date
    09-03-2003
    Location
    UK
    Posts
    95
    Not sure if this is what you want but it is a potential solution. In the first available column use the CONCATENATE function to add the columns together e.g. "=CONCATENATE(A1,B1,C1,D1). Then in the next column use "=IF(ISERROR(FIND("XYLHB",H1))=TRUE,0,FIND("XYLHB",H1))". This will return a value of 1 if it finds the string else 0. Then at the bottom of the column you can just do a sum() tofinf the number of occurrences.

    Is this any help?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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