Use Google Sheet’s MODE Function to Find Frequently Occurring Values

Sheets Header

Should you need to find the most commonly occurring value in your spreadsheet, Google Sheets has a function that automatically analyzes your document for you. Here’s how to use the MODE function to find a value that frequently appears.

Fire up Google Sheets and open a spreadsheet with datasets for which you want to find the most commonly occurring value.

Click on an empty cell and type =MODE(<value1>, [<value2>, ...]) into the cell or the formula entry field, replacing <value1> and <value2> with the values or ranges to consider for calculation. The first value is mandatory, and any additional values are optional. It will look something like this:

=MODE(1,2,3,1,1,5,1,6,8)

Click on an empty cell and type =MODE(<Value1>, [<Value2>, …]), replacing <Value1> and <Value2> with the values or range of data you want to find the mode for.” width=”545″ height=”308″></p>
<p>After you press the “Enter” key, the cell will now contain the most common number of the dataset you put in the function.</p>
<p><img class=

You can also use a range of cells as values in the function. It will look like this:

=MODE(F3:I11)

You can use references to ranges from your spreadsheet in the function as well.

Press the “Enter” key, and the most common value will appear in the cell with the function.

After you press the "Enter" key, the mode will appear in the cell.

However, if your dataset contains more than one commonly occurring value, only the first one will show, ignoring all other possible occurrences. Instead, you will need to use the MODE.MULT function to show all modes that occur in the dataset. It will look like this:

=MODE.MULT(F3:I11)

To show more than one mode that might exist in a dataset, use the MODE.MULT function instead.

Press the “Enter” key, and all values that frequently occur in the dataset will appear in the cell with the function and subsequent cells underneath.

After you press the "enter" key, all modes that exist in the dataset will appear in the cell.

RELATED: The Beginner’s Guide to Google Sheets