Home > DeveloperSection > Articles > LARGE function in Excel

LARGE function in Excel


Excel Excel 
Ratings:
0 Comment(s)
 1624  View(s)
Rate this:

LARGE function in Excel

In this article I have described how to used LARGE function in Excel Sheet. LARGE function returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score.

Syntax

 

LARGE(array,k)

 

Array - is the array or range of data for which you want to determine the k-th largest value.

 

K - is the position (from the largest) in the array or cell range of data to return.

Note:

If array is empty, LARGE returns the #NUM! error value.

If k ≤ 0 or if k is greater than the number of data points, LARGE returns the #NUM! error value.

If n is the number of data points in a range, then LARGE(array,1) returns the largest value, and LARGE(array,n) returns the smallest value.

For example:

LARGE function in Excel


Don't want to miss updates? Please click the below button!

Follow MindStick