SheetFX
≡
<< Go back to all functions

MODE.MULT

The MODE.MULT function in Google Sheets is used to find the most commonly occurring values in a dataset. It returns an array of those values. Whether you're analyzing survey responses, customer preferences, or any other data, the MODE.MULT function can provide valuable insights.

Function Syntax and Parameters

Syntax: MODE.MULT(value1, value2)

Parameters:

  • value1: The first value or range of values to consider.
  • value2: [Optional] Additional values or ranges to consider.

Step-by-Step Tutorial

  1. Using MODE.MULT with individual values:

    • Example: =MODE.MULT(2, 4, 7, 2, 9, 7, 2)
    • Result: [2, 7]

  2. Using MODE.MULT with a range of cells:

    • Example: If A1:A10 has the values 2, 4, 7, 2, 9, 7, 2, 7, 4, 2, then =MODE.MULT(A1:A10) will return [2, 7].

Use Cases and Scenarios

  1. Survey Analysis: Identify the most common responses.
  2. Product Preference: Determine the most popular choices among customers.
  3. Grade Distribution: Find the grades that occur most frequently in a class.

Related Functions

  • MODE: Find the most common value in a dataset.
  • MODE.SNGL: Like MODE, but returns a single value instead of an array.

Related Articles