Excel Formula to Count Max Consecutive Items in a Column

Learn how to create a worksheet formula that counts the max number of occurrences for each unique number in a column using the FREQUENCY, IF, ROW and MAX functions. This solution originally came from Colin Legg at Mr Excel Message Board in 2010.

Topics:

1. (00:00) Introduction
2. (00:05) Review consecutive number tricks
3. (00:25) Create sorted unique list with formula
4. (00:52) Create worksheet formula that counts the max number of occurrences for each unique number in a column using the FREQUENCY, IF, ROW and MAX functions
5. (03:34) Bonus Formula: Spilled MAP and LAMBDA formula
6. () Summary, Closing, Video Links

Download Excel File:

https://excelisfun.net/files/EMT1806-...