MODE() - Find Most Repeated Value in a List in Excel

Add to Favorites
Author:

The MODE() function in Excel allows you to quickly find the most repeated or frequently occuring value within a list or range of data. This allows you to quickly analyze a series of data to do things like finding the highest sales amount for a quarter or the cost of the most expensive part in a project, and so much more.

Note: Arguments for the MODE() function in Excel can be numbers, names, arrays, or other references that contain numbers. Also, any argument in the MODE() function that is text that can't be turned into a number or that throw errors will return an error for the MODE() function. If there are no duplicate values in the list, which means there can be no value repeated more than another, this function will return an error in Excel.

Syntax for the MODE() function in Excel:

MODE(number1, number2, ...)

 

Sample:

MODE() Function in Excel


Excel Function: MODE()

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Tutorial Details
Excel Function: MODE()
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course