Search results
Results from the WOW.Com Content Network
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. Array and K are required.
The LARGE function returns the K-th largest value from a dataset, where K must be a positive integer. Syntax. =LARGE(array, k) Arguments. Note: K should be greater than 0. LARGE (array,1) returns the largest value and LARGE (array,n) returns the smallest value if there are n data points in the range.
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.
The tutorial guides you on how to use LARGE function in Excel to get top n values, sum or average largest numbers in a dataset, get a closest future date, and more.
Excel LARGE function can be used to get the Kth largest value from a range of cells or array. For example, you can get the 3rd largest value from a range of cells.
The Excel LARGE Function [1] is categorized under Excel Statistical functions. The function will return the k largest value, sorted by value in descending order. As a financial analyst, the LARGE function can be used to sort information provided and find the maximum value, such as share price or rate of return for a portfolio. Formula.
Learn how to use Excel's LARGE function for both Mac and PC. Includes numerous formula examples in Excel and VBA (WITH PICTURES).