Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1806-1808.xlsx
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

ExcelIsFunMon, December 12, 2022 6:37pm