|
Featured Tutorial
Featured Macro
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
Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm