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
<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:
You can also use a range of cells as values in the function. It will look like this:
Press the “Enter” key, and the most common value will appear in the cell with the function.
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:
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.