How to use LARGE function in Microsoft Excel

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/logical-formulas/excel-large-function.html
SHARE




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.

image 1

 

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:

image 2

 

1st Example:-

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

image 3

 

Follow the steps given below:-

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

image 4

 

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.

image 5

 

Follow the steps given below:-

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

image 6

 

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

image 7

 

Follow the steps given below:-

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

image 8

 

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.

image 9

 

Follow the steps given below:-

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

image 10

 

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.

image 11

 

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

image 12

 

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.

image 13

 

Follow the steps below given:-

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

image 14

 

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.

image 15

 

Follow the steps given below:-

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

image 16

 

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.

 

image 48

 

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 [email protected]

Please follow and like us:
0


Leave a Reply

Your email address will not be published. Required fields are marked *

To avoid automated spam,Please enter the value *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>