multible if statements of a sequence

[loucifer777]

hello,in a column A:A we have only two numbers(1 and 2)random results,we need a formula to B1 which tracks A:A and if the last number from below is equal with the fifth from below and seventh from below to say 'wow'

example 1
2
2
1
2
1
1
2
1
1

say ''wow''.thanks

[AliGW]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...e-formula.html