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 LARGE function syntax has the following arguments: Array Required. The array or range of data for which you ...

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.

2024年7月15日 · Learn the definition and different uses of the LARGE function in Excel. All the examples are explained with proper explanation.

In this tutorial, learn how to use Excel LARGE function. LARGE Function returns the k-th largest value from the specified range of cells

2024年7月29日 · How to Use Excel Large Function with Text; How to Lookup Next Largest Value in Excel; How to Use LARGE Function with VLOOKUP Function in Excel; How to Use LARGE and SMALL Function in Excel

2024年8月30日 · 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.

2024年8月10日 · This article demonstrates two easy methods with examples of how to use LARGE function with VLOOKUP function in Excel

This Excel tutorial explains how to use the Excel LARGE function with syntax and examples. The Microsoft Excel LARGE function returns the nth largest value from a set of values.

What is the Excel LARGE Function? The Excel LARGE Function is categorized under Excel Statistical functions. The function will return the k largest value, sorted by value in descending order.