## How to use the LARGE function

*Article updated on January 24, 2018*

The LARGE function calculates the k-th largest value from an array of numbers.

Use the LARGE function, for example, to extract the highest number, second highest and third highest from a cell range of numbers.

### Excel Function Syntax

=LARGE(*array*, *k*)

### Arguments

array |
Required. Group of numbers for which you want to calculate the k-th largest value. |

k |
Required. The position in the group of numbers to return, sorted from the largest. |

### Comments

It is possible to use an array of numbers in the k argument, don't forget to enter the formula as an array formula for it to work.

Example, =LARGE(A1:A10, {1,2,3}) extracts the largest, second largest and third largest number in cell range A1:A10 at the same time.

### Articles with the 'LARGE' Function

Extract unique distinct values from a multi-column cell range

Question: I have cell values spanning over several columns and I want to create a unique list from that range. […]