# Finding same patterns in groupings of cells

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.

Be Well...
Grateful  Register To Reply

2. 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?  Register To Reply