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.
Download Excel File: