Hi all,
I need to count the maximum number of consecutive weeks that stock levels reached 0, over a 26 week period for thousands of stock items.
I can count the total instances that reached 0, but I only need to know the longest unbroken period, even if there were two periods of the same duration.
Example attached.
Any help would be appreciated.
Thanks, Feastie.
Bookmarks