The Excel MODE.SNGL function returns the most frequently occurring number in a numeric data set. For example, =MODE.SNGL(1,2,4,4,5,5,5,6) returns 5.
Get most frequently occurring number
A number representing the mode.
=MODE.SNGL (number1, [number2], ...)
number1 - A number or cell reference that refers to numeric values.
number2 - [optional] A number or cell reference that refers to numeric values.
The Excel MODE.SNGL function returns the most frequently occurring number in a numeric data set. Numbers can be supplied as numbers, ranges, named ranges, or cell references that contain numeric values. The MODE.SNGL function will accept up to 254 individual arguments.
The Excel AVERAGE function returns the average of values supplied as multiple arguments. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.