If array is empty, LARGE returns the #NUM! error value. The position (from the largest) in the array or cell range of data to return.
The array or range of data for which you want to determine the k-th largest value. The LARGE function syntax has the following arguments:Īrray Required. For example, you can use LARGE to return the highest, runner-up, or third-place score. You can use this function to select a value based on its relative standing. Returns the k-th largest value in a data set. This article describes the formula syntax and usage of the LARGE function in Microsoft Excel.
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More.
0 kommentar(er)
