MODE function

The Klipfolio MODE function returns the lowest value that most frequently occurs in a range of data.

The syntax for the MODE function is:

MODE( value )

MODE example

Let's look at a MODE function example.

 

A

1 2
2 3
3 4
4 3
5 7
6 7
7  
8 7

The following example is based on the above text from an Excel spreadsheet:

MODE ( A:A )

-> [7]

Related links: