Hi Guys,
First post here. I'd like to find a formula (VBA is not an option in this case) to find the current "streak" of zero-defect weeks in a list of quality data. The data is organized into a fiscal week column and a quality defects column (0 being good).
How can I count, for the current fiscal week (last populated cell), how long the streak has been since the last quality defect? I don't want to add an extra column for running up a cumulative streak, I only have one cell available to me to do a streak calculation for the most recent week.
Any ideas??
Bookmarks