Want to get free access to our Excel functions course?

Fill in your e-mail address and telephone and we will give you 7 days free access to our course The Excel Functions Guide.


In this lesson we will go through how to get the Median, as well as the Mode, of a group of cells.
The median function will give us the middle-most number out of the range, as though they were sorted in ascending order. It contains one argument: The range of cells.
We’ll write Equals, MEDIAN, and then select our range. We are given the number Four, which, if we sort the range from smallest to largest, we can see is true.
If we want to find the most commonly occurring value in the group of cells, we’ll use the MODE function. It consists of the same argument as the MEDIAN function.
We’ll write Equals, Mode, and then select our values. We are shown that the number 6 is the most commonly occurring number of the range.
In this lesson we have looked at the MEDIAN and MODE functions.