Spreadsheet formulas explained, side by side

MODE Function in Excel, Google Sheets, Airtable & Notion

MODE returns the number that appears most often. If several numbers tie, it returns the one that appears first; if nothing repeats, it returns #N/A.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inMODE.SNGL(number1, [number2], ...)
The older MODE() still works and gives the same result. MODE.MULT returns every tied value as a spilled list.
Google Sheets✔ Built inMODE(value1, [value2, ...])
MODE.SNGL and MODE.MULT are also available.
Airtable✘ Not available—
Airtable has no MODE and rollups cannot count how often each value occurs. Group a view by the field and look at the group with the most records instead.
Notion≈ Workaroundlets(x, list, c, x.map(let(v, current, x.filter(current == v).length())), if(max(c) < 2, "", x.filter(let(v, current, x.filter(current == v).length()) == max(c)).first()))
No built-in mode. The formula counts how often each value occurs and returns the first value with the highest count. It returns empty instead of #N/A when nothing repeats.
Try MODE with your own values
One value per line, or separate with commas
Result (as Excel & Google Sheets return it)
5
Your formula, ready to paste
Excel=MODE.SNGL(A2:A8) open excel.new ↗
Google Sheets=MODE(A2:A8) open sheets.new ↗
Airtable✘ No equivalent. Airtable has no MODE and rollups cannot count how often each value occurs. Group a view by the field and look at the group with the most records instead.
Notion
workaround
lets(x, [3, 5, 3, 8, 5, 5, 2], c, x.map(let(v, current, x.filter(current == v).length())), if(max(c) < 2, "", x.filter(let(v, current, x.filter(current == v).length()) == max(c)).first()))

Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.

Value
3
5
3
8
5
5
2

Arguments

ArgumentWhat it means
number1The first number, cell or range.
[number2], ... optionalMore numbers or ranges.

Examples

FormulaResultWhyCopy
=MODE(3, 5, 3, 8, 5, 5, 2)55 appears three times.
=MODE(4, 9, 9, 4)4A tie: 4 and 9 both appear twice, and 4 comes first.
=MODE(1, 2, 3)#N/ANo value repeats.

Examples use Excel / Google Sheets syntax unless noted.

How MODE works

MODE answers “which number comes up most often?”: the most common shoe size sold, the most frequent rating, the usual order quantity. It only works on numbers. Text in a range is skipped, so to find the most common word use =INDEX(A2:A20, MODE(MATCH(A2:A20, A2:A20, 0))), which turns each value into the position of its first occurrence and takes the mode of those positions.

Two behaviours surprise people. When several values tie for most frequent, MODE returns the one whose first appearance is earliest in the data, not the smallest. And when every value occurs only once, the result is #N/A, not the first value. Wrap it in IFERROR if that is a normal situation for your data. Use MODE.MULT in Excel 365 or Google Sheets to list all tied values.

Notion has no mode function, but the formula above builds one from map, filter and length: it counts each value's occurrences, finds the highest count with max, and returns the first value with that count. In Airtable, grouping a view by the field shows the record count of each value.

Frequently Asked Questions

Why does MODE return #N/A?
No number appears more than once (or the range has no numbers at all, for example because they are stored as text).
What is the difference between MODE, MODE.SNGL and MODE.MULT?
MODE and MODE.SNGL are the same and return one value. MODE.MULT returns every value that ties for the highest count as an array.

Part of the Statistics & Counting functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.