MODE Google Sheets Function

What Is MODE Function In Google Sheets?

MODE Google sheets function helps users find the most common value from the given data set. It is one of the commonly used average functions. This inbuilt MODE function is categorized under Statistical functions.

For example, consider the below table showing values in the range A1:A5. Now, let us find the repeated, common value in the dataset using MODE function.

MODE-Google-Sheets-Function-Definition

The steps are:

Step 1: First, we need to select the cell where we want to enter the formula. In this example, let us select cell A6.

Step 2: Next, insert the formula by typing =MODE and select the cell range A1:A5.

Step 3: Press Enter key.

We can see the repeated, most common value in the data set, as shown in the below image.

MODE-Google-Sheets-Function-Definition-1

Likewise, we can use MODE google sheets function.

In this article, let us learn more about the MODE functions.

Key Takeaways
  • MODE function in google sheets is used to find the common value or repeated value in the dataset.
  • Google sheets MODE function is similar to the MODE function in Excel.
  • In google sheets, we can use MODE, MODE.SNGL and MODE.MULT functions.
  • Remember that the MODE.SNGL is used to find the most repeated value whereas MODE.MULT function is used to find all the repeated values in the dataset.
  • Note that the MODE function is categorized under the Statistical functions.

MODE() Google Sheets Formula

MODE google sheets formula is

=MODE(number1,number2…)

Where number1 and number 2 denotes the data or cell range.

In addition, there are 2 more MODE functions (MODE.SNGL and MODE.MULT) available in google sheets as shown in the below image.

MODE-Google-Sheets-Function-Formula

MODE.SNGL works similar to the MODE function and gives the repeated value in the data set.

Meanwhile, MODE.MULT function helps users find more than one or more repeated values in the data.

How To Use MODE Google Sheets Function?

MODE function is used to find the commonly repeated value in the cell range or data in the sheet.

The steps to use MODE google sheets function are:

  1. Choose the cell where we want to find the result.

  2. Insert the =MODE( function and select the cell range.

  3. Press Enter key.

We can see the result or the most repeated value.

For example, consider the below table showing sample and weight in the range A1:A5 respectively. Now, let us find the repeated, common value in the dataset using MODE function.

Step-1

The steps are:

Step 1: First, we need to select the cell where we want to enter the formula. In this example, let us select cell A6.

Step 2: Next, insert the formula by typing =MODE and select the cell range A1:A5.

Step-2

Step 3: Press Enter key.

We can see the repeated, most common value in the data set, as shown in the below image.

Step-3

Now, let us learn more about MODE function, MODE.SNGL and MODE.MULT functions in google sheets with apt examples.

Examples

Let us learn how to use MODE function in google sheets with detailed examples.

Example #1 – Using MODE Google Sheets Function

For example, consider the below table showing sample and weight in the range A1:B6 respectively. Now, let us find the repeated, common value in the dataset using MODE function in google sheets.

MODE-Google-Sheets-Function-Example-1

The steps are:

Step 1: First, we need to select the cell where we want to enter the formula. In this example, let us select cell B7.

Step 2: Next, insert the formula by typing =MODE and select the cell range B2:B6.

Example-1-Step-2

Step 3: Press Enter key.

We can see the repeated, most common value in the data set, as shown in the below image.

Example-1-Step-3

Example #2 – MODE.SNGL Function

For example, consider the below table showing sample and weight in the range A1:B6 respectively. Now, let us find the repeated, common value in the dataset using MODE.SNGL function in google sheets.

MODE-Google-Sheets-Function-Example-2

The steps are:

Step 1: First, we need to select the cell where we want to enter the formula. In this example, let us select cell B7.

Step 2: Next, insert the formula by typing =MODE.SNGL and select the cell range B2:B6.

Example-2-Step-2

Step 3: Press Enter key.

We can see the repeated, most common value in the data set, as shown in the below image.

Example-2-Step-3

LikExample #3 – MODE.MULT Function

Consider the below scenario where the quantity of electronic devices are shown in the cell range A1:B6. Now, let us find the number of repeated values in the data set using MODE.MULT function in google sheets.

MODE Google Sheets Function-Example-3

The steps are:

Step 1: First, we need to select the cell where we want to enter the formula. In this example, let us select cell B7.

Step 2: Next, insert the formula by typing =MODE.MULT and select the cell range B2:B6.

Example-3-Step-2

Step 3: Press Enter key.

We can see the repeated, most common value in the data set, as shown in the below image.

Example-3-Step-3

As we can see, we have two values, 14 and 30 as the result. Since MMULT function gives all the repeated values, we can use MODE.MULT function in google sheets to get all the repeated values.

Important Things To Note

  1. MODE function in google sheets, commonly used with average function is used to find the repeated entry in the dataset.
  2. The syntax or formula of MODE in google sheets is =MODE(number1,[number2]…)
  3. The MODE formula has only one mandatory argument and that is the actual data or cell range which has the repeated value.
  4. The users can simply feed the cell range in the formula.
  5. To insert the formula, simply click on the cell and type =MODE( in google sheets.

Frequently Asked Questions(FAQs)

1. Explain the MODE function in google sheets with an example.

For example, consider the below table showing values in the range A1:A5. Now, let us find the repeated, common value in the dataset using MODE function.

MODE Google Sheets Function-Question-1-Step-1

The steps are:

Step 1: First, we need to select the cell where we want to enter the formula. In this example, let us select cell A6.

Step 2: Next, insert the formula by typing =MODE and select the cell range A1:A5.

Step 3: Press Enter key.

We can see the repeated, most common value in the data set, as shown in the below image.

MODE Google Sheets Function-Question-1-Step-2

2. What is MODE.SNGL and MODE.MULT functions in google sheets?

MODE.SNGL function gives the result of only the most repeated values; whereas, the MODE.MULT function gives the list of all the repeated values in the dataset.

3. Why MODE function is not working?

MODE function (including MODE.SNGL and MODE.MULT functions) may not work when the data set does not contain numeric values or if there are no repeated entries in the data set in google sheets.

Download Template

This article must help us understand the MODE Google Sheets formula and examples. You can download the template here to use it instantly.

Guide to MODE Google Sheets Function. Here we explain how to use MODE Google Sheets with examples & downloadable excel template. You can learn more from the following articles –

XMATCH Function in Google Sheet

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *