I have in a row 14 numbers. 0-4.
I would like to indicate "xxx", in case of appear in this line 5 numbers in sequence that are <> of 0
Example:
0 0 0 0 1 1 3 1 1 0 0 0 0 0 "xxx"
0 0 1 0 0 1 2 3 4 0 1 1 0 0
0 1 1 2 1 1 0 0 0 0 1 1 0 0 "xxx"
Each number is on a cell and the result (xxx) in other.
A:N is my range
Luthius
I would like to indicate "xxx", in case of appear in this line 5 numbers in sequence that are <> of 0
Example:
0 0 0 0 1 1 3 1 1 0 0 0 0 0 "xxx"
0 0 1 0 0 1 2 3 4 0 1 1 0 0
0 1 1 2 1 1 0 0 0 0 1 1 0 0 "xxx"
Each number is on a cell and the result (xxx) in other.
A:N is my range
Luthius