Uploaded April 2014 | Updated September 2026, 1 hour ago

---

Download the file: http:--1drv.ms-1bYwrTa
1. We need to find the 1st negative value.
2. Determine how many values after that are required to make back the 1st negative value.

I show you how to do this in 4 steps.
I didn't even use an array formula!