Tag Archives: LARGE

How to user the LARGE and SMALL Functions

Kornilios Ampatzis/ April 4, 2019/ Tutorials

The need to determine the maximum and the minimum values of a range of cells, is common to almost all types of excel projects.
But in statistics the MIN and MAX functions are not enough. The need to calculate, for example, the third largest or smallest value of a range of cells, is very common.

The LARGE function

Kornilios Ampatzis/ April 4, 2019/ Functions

In statistics the MAX function is not enough. The need to calculate, for example, the third largest value of a range of cells, is very common. This is what the LARGE function calculates. It returns the n-th largest value from an array of numeric values.