How to Find Most Frequent Value in Google Sheets


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:

Google Sheets find most frequent number value

The formula returns two numbers: 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:

Google Sheets find most frequent text value

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

Leave a Reply

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