if series criteria ,extract values

[loucifer777]

hello,at A:A there are values of 1,2 which come randomly.i want at C1 a formula which calculates the following:if the last 2 numbers(from below) are the same in value and order with -5th and-6th number, extract at C1 the numbers in between.please see attachement.thanks

[BMV]

Please Login or Register  to view this content.

But only in the case you would like only one group. If you have long A:A column and would like to get all groups then it must be change.

[loucifer777]

the numbers 1,2 are randomly come and it can continue up to A100 lets say,the formula has to take into consideration that ,not only untill A11.thanks guys

[loucifer777]

bmv,is a long group.thanks alot

[BMV]

Could you extend your example for 2-3 and show how the result should be.

[loucifer777]

it does niot matter bmv,the philosophy is, if the last 2 numbers(from below) are the same in value and (order) with -5th and-6th number, extract at C1 the numbers in between

[loucifer777]

can anybody help,please help
at A:A there are values of 1,2 which come randomly.i want at C1 a formula which calculates the following:if the last 2 numbers(from below) are the same in value and order with -5th and-6th number, extract at C1 the numbers in between.please see attachement.thanks

[loucifer777]

do you need more info?

[BMV]

do you need more info?

I have already written about example in the file that show several group and how result must be looks like.

[loucifer777]

ok,thanks so much