You can use the following formulas to find the most frequently occurring value in a range in Google Sheets:

**Method 1: Find Most Frequently Occurring Number**

=MODE.MULT(A2:A11)

**Method 2: Find Most Frequently Occurring Text**

=INDEX(A2:A11,MODE.MULT(MATCH(A2:A11,A2:A11,0)))

Both methods use the **MODE.MULT** function, which will return multiple values if there are multiple values that occur most frequently.

The following examples show how to use each method in practice.

**Example 1: Find Most Frequently Occurring Number in Google Sheets**

Suppose we have the following list of numbers in Google Sheets:

We can use the following formula to find the most frequently occurring number in the list:

=MODE.MULT(A2:A11)

The following screenshot shows how to use this formula in practice:

The formula returns two numbers: **4 **and **12**.

These are the two numbers that occur most frequently in the range **A2:A11**.

**Example 2: Find Most Frequently Occurring Text in Google Sheets**

Suppose we have the following list of basketball team names in Google Sheets:

We can use the following formula to find the most frequently occurring team name in the list:

=INDEX(A2:A11,MODE.MULT(MATCH(A2:A11,A2:A11,0)))

The following screenshot shows how to use this formula in practice:

The formula returns the text **Mavs**.

This is the text that occurs most frequently in the list.

**Note**: You can find the complete documentation for the **MODE.MULT** function in Google Sheets here.

**Additional Resources**

The following explain how to perform other common tasks in Google Sheets:

How to Calculate Cumulative Percentage in Google Sheets

How to Calculate a Weighted Percentage in Google Sheets

How to Calculate Deciles in Google Sheets