MODE Function

Freebeginner 15 min4 tasks0/66 pts

MODE returns the most frequently occurring number. It is the "most common" size, rating or price. If no number repeats it returns #N/A, which you can catch with IFERROR. Newer Excel lists it as MODE.SNGL; both work the same.

Syntax

MODE(number1, [number2], …)

Example: =MODE(A2:A8) returns the most common shoe size.

Common mistakes

Expecting MODE to work on text (it only looks at numbers).
Not handling the #N/A you get when nothing repeats.

MEDIAN Function FLOOR & CEILING Functions