I have a spreadsheet where I need to calculate the consecutive months in a row where a site is showing up 'flagged' as a 1. This needs to restart every time they show up as 0 (i.e, fall off the flagged list). The max frequency formulas I have tried from other forums don't work as they return the max consecutive values despite the site falling off in current month(s).