MODE

MODE finds the most common number in a dataset. Modern Excel splits it into MODE.SNGL (one value) and MODE.MULT (an array), but MODE still works for the common case.

Excel

=MODE(A2:A6)

Google Sheets

=MODE(A2:A6)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1A2:A6 is the range of numbers.
2MODE finds the value that repeats most.
33 appears three times, so the result is 3.

Need a version for your data?

Try: “Find the most common number in column A”

COUNTA COUNTBLANK AVERAGEA

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

MODE

Try it with your data

How it works

Related