Menu
EXCEL MODE FUNCTION
Excel MODE Function Introduction
The MODE function returns the most common value or the most frequently occurring
numbers in a group.
Description of Excel MODE Function
Syntax:
=MODE (number1, [number2], …)
Parameter list:
number1 – a number or cell reference that refers to numeric values.
number2 – [optional] a number or cell reference that refers to numeric values.
Step By Step Guide of MODE Function
For example:
=MODE(1,2,2,3,3,3,3,34,4,5,5,5,6) returns 3.
Numbers can be supplied as numbers like the above example or ranges like
=MODE(A1:A11,B4:B10) or named ranges, or cell references that contain numeric values. Up to 255 numbers can be supplied.
If the set of supplied numbers does not contain any duplicates, MODE will return #N/A
error.
Key Points
MODE is now classified as a “compatibility function”. Microsoft recommends that MODE.SNGL or MODE.MULTI be used instead.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
