Extract match of header patterns

[Kishan]

Hi,</SPAN></SPAN>

Data column is column C</SPAN></SPAN>

Header F2:H3 values are brought by formula and F4:H4 values are consonants </SPAN></SPAN>
Header-1 F2:F4 = Pattern 2X1</SPAN></SPAN>
Header-2 G2:G4 = Pattern 2XX</SPAN></SPAN>
Header-3 H2:H4 = Pattern 2X2</SPAN></SPAN>

I want that look each header pattern in the column C and bring out the match pattern and place in their corresponding columns as shown below in example</SPAN></SPAN>

Book1
	A	B	C	D	E	F	G	H	I	J
1
2						2	2	2
3						X	X	X
4						1	X	2
5			P1			P1	P1	P1
6			X
7			1
8			X
9			2				2
10			X				X
11			X				X
12			X
13			X
14			2			2
15			X			X
16			1			1
17			X
18			1
19			1
20			2					2
21			X					X
22			2					2
23			X
24			1
25			1
26			1
27			X
28			X
29			2			2
30			X			X
31			1			1
32			X
33			1
34			1
35			2			2
36			X			X
37			1			1
38			X
39			2
40			1
41			1
42			2				2
43			X				X
44			X				X
45			1
46			1
47			2
48			2
49			1
50			X
51			X
52			1
53			2			2
54			X			X
55			1			1
56			X
57			1
58			1
59			2					2
60			X					X
61			2					2
62			1
63			2
64
65
66
Sheet12

Thank you in advance</SPAN></SPAN>

Using Excel 2000</SPAN></SPAN>

Regards,</SPAN></SPAN>
Kishan</SPAN></SPAN>

 

[DRSteele]

Put this formula in F6 and copy across then downwards. Your software is antiquated, so you might need to enter it with Ctrl+Shift+Enter. Note that your sample missed one match starting on Row 22 for the F-key (2 X 1).

F6

=IF(OR(AND(OFFSET($C6,0,,3)=F$2:F$4),AND(OFFSET($C6,-1,,3)=F$2:F$4),AND(OFFSET($C6,-2,,3)=F$2:F$4)),$C6,"")

 

[Kishan]

Note that your sample missed one match starting on Row 22 for the F-key (2 X 1).

F6

=IF(OR(AND(OFFSET($C6,0,,3)=F$2:F$4),AND(OFFSET($C6,-1,,3)=F$2:F$4),AND(OFFSET($C6,-2,,3)=F$2:F$4)),$C6,"")

DRSteele, yes noticed after applying the formula it was missing thank you for the observations

Put this formula in F6 and copy across then downwards. Your software is antiquated, so you might need to enter it with Ctrl+Shift+Enter.
F6

=IF(OR(AND(OFFSET($C6,0,,3)=F$2:F$4),AND(OFFSET($C6,-1,,3)=F$2:F$4),AND(OFFSET($C6,-2,,3)=F$2:F$4)),$C6,"")

DRSteele, superb it worked perfect as required. </SPAN></SPAN>

I do appreciate for your kind help</SPAN></SPAN>

Kind Regards,</SPAN></SPAN>
Kishan</SPAN></SPAN>

 

[DRSteele]

You're welcome. I'm glad it helped you.