Excel Forum

Excel Magic Trick 713: Count Max Number In Succession in Column FREQUENCY function magic!

See how to count the max number of items in succession in a column of data using the FREQUENCY, IF, MAX and ROW functions. Amazing array formula from Colin Legg at the Mr Excel Message Board.

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.