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
Bookmarks