Tag Archives: SMALL

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 SMALL function

Kornilios Ampatzis/ April 4, 2019/ Functions

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