Hi!
I want to know what formula can I use to identify the number of consecutive times that a value below 1 happens in a sequence. Because these are a sequence of values per day, I want it to count starting on the last day available and only if this last day is below 1.
In the example in the attached picture the formula result should be 4.
Thanks.
excel.jpg
Bookmarks