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 is the longest.
EX:
-0.25
-0.72
-0.43
0.05
0.62
-0.05
-0.29
-0.06
-0.34
0.46
1.52
0.96
-0.88
0.55
The answer is 4 because it has four numbers next to each other less than zero.