Count completed cycle in row with multi columns

[Kishan]

Using Excel 2000

Hi,

Data in cells C6:I80 require result "counts for completed cycle" in column K

Cycle of 3 characters "1X2" for example...
If cycle start with "1" has to finish with "X or 2"
If cycle start with "X" has to finish with "1 or 2"
If cycle start with "2" has to finish with "1 or X"

Cycle required minimum 3 rows to be completed
Step-1 check "1X2" cycle in the columns C through I, in the row 6, 7 & 8 (so in the row 8 didn't Found cycle result = 0 In K8)

Step-2 check "1X2" cycle in the columns C through I, in the row 6, 7, 8 & 9 (so in the row 9 Found 1 cycles in "I6, I7, I8, I9" result = 1 In K9)

RESET I9 AND STRAT COUNTING NEW CYCLE FROM I10

Step-3 check "1X2" cycle in the columns C through I, in the row 6, 7, 8, 9 & 10 (so in the row 10 Found 2 cycles in "C6, C7, C8, C9, C10" & in "G6, G7, G8, G9, G10" result = 2 In K10)


RESET C10 AND STRAT COUNTING NEW CYCLE FROM C11
RESET G10 AND STRAT COUNTING NEW CYCLE FROM G11

Step-4 check "1X2" cycle in the columns C through I, in the row 6, 7, 8, 9, 10 & 11 (so in the row 11Found 2 cycles in "D6, D7, D8, D9, D10, D11" & in "E6, E7, E8, E9, E10, E11" result = 2 In K11)

Example.... all results are calculated manually may me find some errors.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1
2
3
4											Cycle
5			C1	C2	C3	C4	C5	C6	C7		Completad
6			X	1	1	1	2	1	2
7			X	X	2	1	X	X	1
8			X	1	1	1	2	1	2		0
9			2	1	1	X	2	1	X		1
10			1	X	1	X	1	1	2		2
11			X	2	X	X	2	X	1		2
12			X	1	1	2	1	1	1		1
13			1	X	X	2	1	X	1		0
14			1	1	1	2	X	X	X		2
15			1	X	X	1	1	1	1		0
16			X	1	X	2	1	2	X		1
17			1	1	X	1	2	1	X		0
18			1	1	1	1	1	X	1		0
19			X	1	1	X	X	1	1		1
20			1	1	1	1	2	1	X		0
21			1	1	1	2	2	1	1		0
22			2	1	X	1	1	X	1		1
23			1	1	1	1	1	2	1		1
24			X	1	1	2	1	1	2		1
25			1	1	1	1	X	1	1		1
26			X	1	1	1	1	2	1		0
27			1	2	X	X	X	X	1		3
28			1	1	1	2	1	2	X		0
29			1	1	1	2	2	1	X		1
30			1	1	1	X	1	1	1		0
31			1	1	1	X	1	1	1		0
32			1	X	1	1	2	1	1		1
33			2	2	1	1	X	1	X		2
34			1	X	1	2	1	1	1		0
35			2	1	1	1	2	X	1		1
36			1	X	X	2	1	1	2		1
37			X	1	1	1	1	1	1		1
38			X	2	1	1	X	X	1		2
39			X	1	2	1	2	1	X		1
40			1	1	1	X	X	1	2		2
41			X	X	X	1	1	X	1		1
42			2	X	2	1	X	1	X		2
43			X	X	1	2	X	1	2		1
44			X	X	1	X	1	1	1		1
45			1	1	X	1	1	2	1		1
46			1	1	1	1	X	2	2		0
47			2	X	1	1	1	1	1		1
48			1	2	1	X	2	1	2		2
49			X	1	X	1	2	1	2		0
50			X	1	1	1	1	X	1		1
51			X	1	X	1	1	X	2		0
52			X	1	1	1	X	X	1		1
53			X	1	1	2	2	X	1		1
54			2	1	X	2	1	X	X		2
55			X	X	2	1	X	1	1		1
56			1	X	2	X	1	2	1		1
57			X	2	X	1	1	1	1		0
58			1	1	X	1	1	X	1		0
59			1	1	X	1	1	1	X		0
60			2	1	X	1	1	1	2		2
61			X	1	2	2	X	1	1		0
62			2	1	1	1	2	2	1		2
63			1	1	1	2	1	1	1		1
64			1	X	2	1	X	1	1		0
65			1	X	1	X	1	1	X		1
66			X	X	X	1	1	1	1		1
67			X	X	2	2	1	2	1		0
68			1	1	2	1	1	1	1		0
69			X	1	1	1	X	1	1		0
70			1	1	1	2	X	1	X		0
71			1	X	1	1	1	2	X		0
72			1	1	X	1	X	X	X		2
73			1	X	1	X	1	X	2		1
74			1	1	X	2	2	1	1		1
75			1	X	X	1	X	1	1		0
76			1	X	X	X	X	1	2		0
77			2	X	1	X	1	1	1		1
78			1	1	X	1	2	2	2		2
79			1	1	1	1	X	1	1		0
80			1	1	1	1	2	1	X		0
81
82
Sheet1

Thank you in advance

Regards,
Kishan

 

[Kishan]

Bump

 

[Kishan]

Bump

 

[Kishan]

Bump