Count Maximum Number of Consecutive Occurrences of a value in a Column Count Maximum Number of Consecutive Occurrences of a value in a Column Cell C3 formula Counts Maximum Number of Consecutive Occurrences, of a value in a Column – Maximum Consecutive Occurrences of the number 5 (cell B3 value) in column A. ...