[Solved] Count consecutive positive numbers

[Sheen]

There is a column with positive and negative numbers in random order. I would like to count the maximum streak of positive numbers and a maximum streak of negative numbers. For instance:
10
-5
2
56
-45
-50
-55
-32


MAx positive streak is 2, max negative is 4.

[MrProgrammer]

I would like to count the maximum streak of positive numbers and a maximum streak of negative numbers.

201812121141.ods

(10.56 KiB) Downloaded 133 times

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Zizi64]

Use one (or two) helper column for checking if the actual and the previous number has same sign or not. Flag and count the same negative number pairs with a negative counter, and flag and count the same positive number pairs with a positive counter. The different sign will reset the counters.

Finally you can search the MIN() The negative number with large absolute value, and the MAX() the positive number with large absolute value in the helper column/s/.

(SAME as suggested by MrProgrammer. I am too slow)

[gerard24]

MrProgrammer solution is the best and easiest solution, but this can be done whithout helper.
This is an array formula, entered with Shift+Ctrl+Enter.

Code: Select all

=MAX(FREQUENCY(IF(A1:A8>0;ROW(A1:A8));IF(A1:A8<0;ROW(A1:A8))))