I have a column of numbers in col C, the numbers vary from -2.00 to +2.00. I’d like a macro that will help find all the group of next-to-each-other negative numbers and compare them and let me know which one appear most often.
EX:
-0.25
-0.72
-0.43
0.05
0.62
-0.05
-0.29
-0.06
0.46
1.52
0.96
-0.34
-0.88
-0.05
-0.29
-0.06
-0.05
0.29
-0.06

The answer is 3 because the three negative-numbers-next-to-each-other appear most frequent.

Any idea?

Thanks in advance,

VBisgreat