Excel Forum
Similar Content
Count The Number of Words in a Cell or Range of Cells in Excel - UDF
Macro: Count words in cells with this user defined function (UDF). This UDF allows you to count t...
OFFSET Function in Excel
Tutorial: The OFFSET function in Excel returns a cell or range reference that is a specified number...
Count the Number of Cells that Contain Specific Text in Excel
Tutorial: How to count the number of cells that contain specific text within a spreadsheet in Excel....

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.