Main Profile

At A Glance

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
Length: 05:37

Contact

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

Want more info about Excel Magic Trick 713: Count Max Number In Succession in Column FREQUENCY function magic!? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question