repeat of sequence ?

[mcsim]

how can i find repeat of sequence in one column .

example :

column = A


a7 = value 200
a8 = value 300
a9 = value 500
a10 = value 50
et cetera

sequence = 200,300,500

i want to find how many time this sequence (200,300,500)repeat in the column , any idea ?


thanks

mcsim

 

[Historian]

In B7 enter =IF(AND(A7=200,A8=300,A9=500),1,0) and fill down.

Sum column B

 

[Aladin Akyurek]

One way...

Let A1:A13 house

{"Values";10;20;30;200;300;500;2;3;4;200;300;500}

and C1:C4

{"Seq";200;300;500}

In D2 enter:

=SUMPRODUCT((A2:A13=C2)*(A3:A14=C3)*(A4:A15=C4))

See...

Book1
	A	B	C	D
1	Values		Seq	Count
2	10		200	2
3	20		300
4	30		500
5	200
6	300
7	500
8	2
9	3
10	4
11	200
12	300
13	500
14
15
Sheet1