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:
- (00:00) Introduction
- (00:05) Review consecutive number tricks
- (00:25) Create sorted unique list with formula
- (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
- (03:34) Bonus Formula: Spilled MAP and LAMBDA formula
- () Summary, Closing, Video Links
Download Excel File:
https://excelisfun.net/files/EMT1806-...