# How to use LARGE function in Microsoft Excel

http://www.exceltip.com/logical-formulas/excel-large-function.html

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:

1st Example:-

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

• 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.

2nd Example:-

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

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

• Function has returned 30 minutes 4 seconds, which is the 2nd largest value

3rd 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.

• 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 1st largest value.

4th Example:-

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

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

It means LARGE function ignores blank cells too.

5th 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.

• 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

6th 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.

• 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.

7th Example:-

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

• 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