Dear Members
I am trying a make formulas in the sheet attached following is my sheet's data
I have different positive and negative numbers in column B of the the sheet
In column C values are cumulative from column B
Now What i want to do is
1. Maximum number of consecutive +ve Numbers (Streak) in Column B
2. Sum of Max Consecutive +ve numbers
3. Cell reference of starting maximum Positive consecutive numbers (Streak) in column B whose numbers are calculated in column "F"
4. Maximum number of consecutive -ve Numbers (Streak) in Column B
5. Sum of Max Consecutive -ve numbers
6. Cell reference of starting maximum Positive consecutive numbers (Streak) in column B whose numbers are calculated in column "I"
any body who have solution to this please help me
Bookmarks