This article describes the formula syntax and usage of the LARGE function in Microsoft Excel. Description. 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)

The Excel LARGE function returns a numeric value based on its position in a list when sorted by value in descending order. In other words, LARGE can retrieve the "nth largest" value – 1st largest value, 2nd largest value, 3rd largest value, etc.

Jul 15, 2024 · LARGE(array,1) returns the largest value and LARGE(array,n) returns the smallest value if there are n data points in the range. This function works only with numeric values , ignoring text, blank cells, and logical values.

If you have a list of numbers (A2:A4) and you want to get the largest number from the list, you can use the following LARGE function: =LARGE(A2:A4,1) Here the Kth value is 1, which would return the largest number from the range of numbers.

Guide to LARGE Function in Excel. Here we discuss the LARGE Formula excel and how to use LARGE in excel along with excel example and downloadable excel templates.

Jul 29, 2024 · This article shows how to use excel large function with criteria. You can download the workbook to learn the method.

Aug 30, 2024 · The LARGE function of Excel returns the k-th largest value from an array or range of values. = LARGE (Array, k) Array specifies the range or the array from where the largest value is sought.

The LARGE function will return the largest specified number from a given range or data set. For example, LARGE can return the 2nd largest value from a column or the 4th largest value from an entire table.

The LARGE Excel function calculates the k th-largest value in the specified array range, considering the data points in descending order. Thus, the function is useful for finding values, such as top scores and second and third-highest values in a given array.

=LARGE(array,k) The formula uses the following arguments: Array (required argument) – This is the array or range of data for which we wish to determine the largest value. K (required argument) – This is an integer that specifies the position from the largest value in the array or range of cells of data to return. How to use the LARGE ...