*In this article, we’ll learn about LARGE function in Microsoft Excel.*

*In Microsoft Excel, LARGE function returns the k’th largest value from an array or set of data.*

* *

*With the help of examples, let us understand the use of LARGE function in Excel.*

Refer to these 7 different examples for the usage of LARGE function in Microsoft Excel on the basis of following sample data:

**1 ^{st} Example**:-

In this example, we want to return the largest value according to the required position.

**Follow the steps given below**:-

- Enter the function in cell A14
- =LARGE(A8:A12,1)
- Press Enter
- The Function has returned 8

LARGE function takes two arguments.The first argument is “Array” from which we want to select the K’th largest value and the second is “K” which is the position in the array from largest to return.

**2 ^{nd} Example:-**

In this example, we have time in range for which we want to retrieve 2^{nd} largest time value.

**Follow the steps given below**:-

- Enter the function in cell B14
- =LARGE(B8:B12,2)
- Press Enter

- Function has returned 30 minutes 4 seconds, which is the 2
^{nd}largest value

**3 ^{rd} Example:-**

In this example, we’ll learn how we can find out the largest value if one of the cells of selected range contains text.

**Follow the steps given below:-**

- Enter the function in cell C14
- =LARGE(C8:C12,1)
- Press Enter

Function has returned 9; it is because LARGE function ignores text in the array or the provided data range considers cells which contain number values only and, in this example, 9 is the 1^{st} largest value.

**4 ^{th} Example**:-

In this example, we have a blank cell within a range from which we want to retrieve the largest value.

**Follow the steps given below**:-

- Enter the function in cell D14
- =LARGE(D8:D12,1)
- Press Enter

It means LARGE function ignores blank cells too.

**5 ^{th} Example**:-

In this example, we’ll see what happens if we enter K’th value 0 or larger than the number of data points in array.

**Follow the steps given below**:-

- EnterLARGE function in E14 and select E8 to E12 range
- We will enter 0 as K’th number and press Enter
- The function will return #NUM error; it is because the K’th value cannot be less than or equal to 0

**6 ^{th} Example**:-

We have taken this example just for your knowledge. In this example, we have taken blank cells of the range for which we want to retrieve the largest value.

**Follow the steps below given:**-

- Enter =LARGE(F8:F12,1) in cell F14
- Press Enter, function will return #NUM error

**Note**: – Both arguments are a must and cannot be empty which is why function returned an error here.

**7 ^{th} Example:-**

In this example, we have taken #N/A error to learn that can we retrieve largest value from the error containing range.

**Follow the steps given below:-**

- Enter the function in cell G14
- =LARGE(G8:G12,1)
- Press Enter

The function has returned the #N/A error which is there in the cell G10. So, the function would return an error if there is an error value anywhere in your data set or array.

This is the way to use LARGE function in Microsoft Excel to get the largest value.

# Video: How to use LARGE function in Microsoft Excel

Watch the steps in this short video, and the written instructions are above the video

*If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook. *

*We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com*