MODE Function Explained
The MODE Function in Microsoft Excel returns the most frequently occurring, or repetitive, value in an array or range of data. It takes up to 255 arguments, which can be numbers, names, arrays, or references that contain numbers. The MODE Function is useful for finding the most common value in a data set.
MODE Function Syntax
MODE(number1, [number2], ...)
number1: The first number or range of numbers for which you want to calculate the mode.number2: (optional) Additional numbers or ranges of numbers for which you want to calculate the mode.