# LARGE Function - Get the Highest Values from a List in Excel

Author:
##### BLACK FRIDAY SALE (65%-80% Off)

Excel Courses Online
Video Lessons Excel Guides

Return the largest value from a list, or any of the top values, in Excel.

This method uses the LARGE() function.

### Sections:

Syntax

Example - Largest Value

Example - Any Top Value

Notes

## Syntax

``````=LARGE(array, k)
``````
Argument Description
Array The range from which you want to get the largest value, or just any top value.
K

Which top value you want to get.

1 means to get the highest value.

2 means to get the second highest value.

Etc.

## Example - Largest Value

Get the largest value from a list.

``````=LARGE(A1:A5,1)
``````

A1:A5 is the range of values.

Result:

## Example - Any Top Value

Let's get the 3rd highest value.

``````=LARGE(A1:A5,3)
``````

A1:A5 is the range of values.

Result:

## Notes

This is a simple function but one that is often forgotten.

This works great when you want to do something like return the top 3 values from a list or find the top performer etc.

Make sure to download the sample file for this tutorial to work with these examples in Excel.

Excel Function: LARGE()

#### Question? Ask it in our Excel Forum

##### Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

Tutorial Details
Excel Function: LARGE()