HomeApplicationOffice informationThe MODE function (returns the value with the most frequent

The MODE function (returns the value with the most frequent occurrence in an array or data range) in Excel

MODE returns the most frequently occurring, repeated value in a given data array. MODE is not as common as other functions, but sometimes you still have to use MODE to get statistics when needed.

The MODE function (returns the value with the most frequent occurrence in an array or data range) in Excel Picture 1

The following article describes the syntax and usage of the MODE function in Excel.

Description

The MODE function returns the value with the most frequent occurrence in an array or data range.

Syntax

= MODE (number1, [number2] .)

Inside:

- number1: the first argument that you want to calculate weak, required.

- number2: the next argument is an optional argument and a maximum of 255 arguments.

You can use a single array or reference an array instead of arguments.

Note

- Arguments can be numbers, arrays, or references that contain numbers.

- Arguments that are text or error values ​​that cannot be converted into numbers will cause the function to fail.

- If an argument, reference, or array contains a logical value, text, or a blank cell, it will be ignored, cells with a value of 0 will be counted.

- If no argument is repeated more than 2 times, the function displays an error.

- There are many numbers with the same frequency of occurrence, the result will be the first argument appears.

For example

Find the number with the most frequent occurrence in the Values ​​column in the data table:

The MODE function (returns the value with the most frequent occurrence in an array or data range) in Excel Picture 2

You can apply the MODE function with the arguments that contain cells separated by commas as follows: = MODE (C6, C7, C8, C9, C10, C11).

The MODE function (returns the value with the most frequent occurrence in an array or data range) in Excel Picture 3

In addition, you can also apply the MODE function with an array argument containing the values: = MODE (C6: C11).

The MODE function (returns the value with the most frequent occurrence in an array or data range) in Excel Picture 4

Although the MODE function has now been replaced by new functions with greater accuracy and names that reflect their uses, MODE is still used. With the syntax and usage of the MODE function is very simple, you can easily use the function. Good luck!

3.5 ★ | 2 Vote

You should read it

May be interested

  • Hide value 0 in ExcelPhoto of Hide value 0 in Excel
    in the process of working with excel spreadsheets, for some reason, sometimes you want to hide all zero values. to do this, you only need to perform very simple steps, but if you do not pay attention you may not know how to do it.
  • Use Sparklines in ExcelPhoto of Use Sparklines in Excel
    spark lines in excel is a small chart that you can put inside cells to view data and charts on the same table. you may know a lot about how to use charts in excel but maybe you do not know sparklines.
  • The MIN and MAX functions (the smallest and largest value functions) in ExcelPhoto of The MIN and MAX functions (the smallest and largest value functions) in Excel
    the function to return the maximum value (max) and the function to return the minimum value (min) are two common statistical functions used by a lot of people in the process of manipulating and processing data in excel.
  • Hide / show the Formula Bar in ExcelPhoto of Hide / show the Formula Bar in Excel
    hide / show the formula bar in excel - many times, when calculating, processing data, you accidentally hide the formula bar in excel without knowing it, until you need to use it, you do not know what to do. how to display that formula bar again?
  • How to write fractional values ​​in ExcelPhoto of How to write fractional values ​​in Excel
    sometimes you enter fractions into excel data cells but it shows the time format. you do not know how to handle the input data is displayed as a fraction.
  • Insert text anywhere in WordPhoto of Insert text anywhere in Word
    insert text into any position in word, the following article shows some ways to insert text in the margins of a page with features available in word.

Office information