# MODESNGL

The **MODESNGL** function works similarly to the MODE function and returns the single most frequently occurring value in a dataset. When multiple values are repeated, it returns the first number that appears the most frequently. 

### Syntax

```javascript
MODESNGL(number1, [number2], ...)
```

### Arguments

The MODESNGL function syntax has the following arguments:

* number1, number2, ... - The numbers or range of values for which you want to find the most frequent value. Required.

### Example

<pre class="language-javascript"><code class="lang-javascript"><strong>MODESNGL(10, 20, 30, 20, 40)
</strong>// returns 20
<strong>MODESNGL(5, 8, 5, 10, 8, 5, 8)
</strong>// returns 5
</code></pre>

If multiple values share the highest frequency, the function returns the first one encountered.

You can use the MODESNGL function to determine the most common value in a dataset when analyzing frequently occurring metrics such as sales, scores, or costs.

{% hint style="warning" %}
If no values are repeated, the **MODESNGL** function returns a **#VALUE!** error.
{% endhint %}

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FcJGeKqZUr4OFa29z9tZV%2F2026-02-16_11h31_48.png?alt=media&#x26;token=bc979b73-6879-4b6a-a225-cd3ab29affcd" alt=""><figcaption><p>MODESNGL function</p></figcaption></figure>

{% hint style="info" %}
We can also use the [**SELECT**](https://docs.inforiver.com/formula-syntax/measure-column-selection-functions/select) function to select a range of columns from 1 to 4 for the 'Revenue' measure (2022 Revenue - 2025 Revenue).
{% endhint %}

### Excel Equivalent

[MODESNGL](https://support.microsoft.com/en-us/office/mode-sngl-function-f1267c16-66c6-4386-959f-8fba5f8bb7f8)