Google Sheets MODE Function | How to Get the First Most Common Value | Google Sheets Function

Use the Google Sheets MODE function to get the first most common value
in a range or array. For example, consider this array {25,30,30,10,15,15}. If you use this array as the attribute for the MODE function in Google Sheets, the function will return 30, as it is the first most common number than any of the other numbers in the array.

Here is the format of MODE:

=MODE(value1,[value2],...)

Start the formula with an equal-to symbol.

MODE is the name of the function.

value1 is the first value or range MODE should consider to get the most common value.

value2 is the second value or range, and is optional.

Let's look at an example:

=MODE(A1:A5)

Say A1=100, A2=150, A3=100, A4=75, and A5=120. Then the above formula returns 100, because it is the most common value in the range and the other numbers are not common.

Let's look at another example:

=MODE(A1:A5)

Say A1=100, A2=150, A3=100, A4=75, and A5=150. What will the MODE function return now? 100 or 150? Note that there are two common values in the range. MODE will return the first most common value. In this case, that number is 100.

If you were to change A1 to 150 and A5 to 100, then the function will return 150.

If you want to get the values that are most common in the range, then you have to use the Google Sheets MODE.MULT function.

Here is the final example that uses the optional second attribute of the function:

=MODE(A1:A5, 5)

Assume that A1=5, A2=15, A3=5, A4=15, and A5=20. The formula will return 5, because it is the most common value, considering the second attribute also.

Do take a look at this video tutorial, which gives the steps to use the Google Sheets MODE function with examples.