How to get largest value or number in Microsoft Excel / How to use LARGE function (formula) in Micosoft Excel

LARGE

Use of LARGE function/formula in Microsoft Excel:

This function in Microsft Excel returns the K-th largest value in selected data cells range.
This function also used to select the first, second, third to 10th largest position in a list of selected data cells range.

Syntax/Formula:

The syntax of LARGE function in Microsoft Excel is below.

=LARGE(array,k)

Example 1:

Step 1 : First type number  1,2,3,4 & 5 starting from cell B5 to B9

Step 2 : Type formula  =LARGE(B5:B9,1) in cell B11 and press enter.

LARGE

Example 2:

Step 1 : First type number  1,2,3,4 & 5 starting from cell B15 to B19

Step 2 : Type formula  =LARGE(B15:B19,2) in cell B21 and press enter.

LARGE

Example 3:

Step 1 : First type number  1,2,3,4 & 5 starting from cell B25 to B29

Step 2 : Type formula  =LARGE(B25:B29,3) in cell B31 and press enter.

LARGE