Excel Formula to Count Max Consecutive Items in a Column
Excel
Dec 14, 2022 12:00 AM

Excel Formula to Count Max Consecutive Items in a Column

by HubSite 365 about ExcelIsFun

Data AnalyticsExcelLearning Selection

Download Excel File: https://excelisfun.net/files/EMT1806-1808.xlsxLearn how to create a worksheet formula that counts the max number of occurrences for each...

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-...