BenefitRich
New Member
- Joined
- Apr 1, 2011
- Messages
- 7
I have a large range of automatically generated columns that report daily predicted inventory levels going off into the future about a year so that's 360+ columns of data. These numbers can be positive, negative, or 0.
Given a user supplied integer "N" I need to find the StartDate of the Nth range of negative numbers in the data as well as the last corresponding consecutive negative number. It is possible that there is only one day that is negative. That range would start and end on the same date.
I have uploaded an example document here.
Of course, the actual report has hundreds of lines of data, so if at all possible, an array formula / helper-row would best be avoided.
I only know how to find the first negative value in the range and that's it
Thanks in advance!
--R
Given a user supplied integer "N" I need to find the StartDate of the Nth range of negative numbers in the data as well as the last corresponding consecutive negative number. It is possible that there is only one day that is negative. That range would start and end on the same date.
I have uploaded an example document here.
Of course, the actual report has hundreds of lines of data, so if at all possible, an array formula / helper-row would best be avoided.
I only know how to find the first negative value in the range and that's it
Thanks in advance!
--R