Using the Excel MODE Function
SummaryThe Excel MODE function returns the most frequent value in a an array or range of data.
The MODE function is now considered a compatibility function in Excel. It is recommended to use either MODE.SNGL or MODE.MULT.
Syntax=MODE (number1, [number2], ...)
Syntax BreakdownNumber 1
Required. First number argument for which you want to find the mode, or most frequently occurring value. Inputs can be an array, number, or reference.
Number 2 and subsequent number arguments are optional. The function can accept up to 255 arguments.
Usage NotesMODE returns the most frequently occurring number in a data set. If a given data set doesn't contain any duplicate numbers, the function returns the #N/A error.
If a number argument is an array or reference, and the array or reference contains text, logical values, or empty cells, they will be ignored. Cells with a zero value will be included.
The function will return an error if arguments include error values or text that cannot be translated into a number.
MODE, along with AVERAGE and MEDIAN, is a measure of central tendency.