I have a column with thousands of positive and negative numbers like in this example:
110.9
-100
-100
129.9
155.8
-100
120
-100
110
116
-100
117
-100
113.1
-100
I want to be able count how often and for how long the alternating pattern of positive and negative numbers occurs like so + - + - + - + - etc,, so ----- and +++++ can be ignored.
Any idea's?
