The MODE is one of the very simple statistical function in Google Sheets. This time we can see how to use Google Sheets MODE function.
It is easy to find the most repeating date or number from a dataset using the MODE Google Sheets function. I will come to the Syntax part later. Before that let me explain to you what Google Sheets tells about this function.
In their words, we can use the MODE function to return the most commonly occurring value in a data set. Here lies the secret. Most commonly occurring value can be a date or numeric value as Google Spreadsheet considers date as a value.
At this point, I suggest you (not necessary) go through my ultimate Google Sheets tutorial on Date functions because I am going to use one date function here that is To_date.
1. The complete Google Sheets date functions.
2. How to return Nth Occurrence of a Day in a Month.
Now let us back to our tutorial on MODE function. Let me explain to you how to use MODE function in Google Sheets with few examples.
Syntax:
MODE(value1, [value2, ...])
There is nothing confusing in the syntax to explain. You can easily grasp it from the below examples.
How to Use Google Sheets Mode Function to Return Most Repeating Numeric Value
=mode(1,2,2,3,4,4,4,5)
The above MODE formula will return the most occurring number in it, i.e. 4 which repeats 3 times.
Hope you could understand how to use MODE function in Google Sheets. It’s so simple. No complications like the functions DSUM, SUMPRODUCT, QUERY etc.
Now one more example that with a range of data.
In the above Mode function example, the most repeating number is 100. So the function will return it.
How to Use Mode Function to Return Most Repeating Date Value
This also I can explain with an example.
If you apply Mode function to a range of values that contains dates, the result would be a value equal to the date. To covert that value to date, I’ve used to_date function combined with MODE function.