If you need to find the most commonly occurring value in your spreadsheet easily then Google Sheets has a function that automatically analyzes your document for you. Here’s how to use Google Sheet’s MODE function to find Frequently Occurring Values.
How to Use Google Sheet’s MODE Function
Start with the Google Sheets and open a spreadsheet with datasets for which you want to find the most commonly occurring value.
Then simply click on an empty cell and type =MODE(<value1>, [<value2>, …]) into the cell or the formula entry field, replace <value1> and <value2> with the values or ranges to consider for calculation.
The first value is mandatory and any other additional values are optional. It will look something just like this:
=MODE(1,2,3,1,1,5,1,6,8)
After pressing the “Enter” key, the cell will now contain the most common number of the dataset you put in the function.
You can also use a range of cells as values in the function. It will look like this:
=MODE(F3:I11)
Simply 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 then only the first one will show, ignoring all other possible occurrences.
Instead, you have to use the MODE.MULT function to show all modes that occur in the dataset. It will look just like this:
=MODE.MULT(F3:I11)
Simply 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.
