The LARGE function takes twoarguments,arrayand k.Arrayis anarrayorrangeof numeric values.
The argumentkrepresents position or rank.
For example, to return the largest value inarray, provide 1 fork.
To return the fifth largest value inarray, provide 5 fork.
To get nthsmallestvalues, see theSMALLfunction.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
from a set of numeric data.
RANK can rank values from largest to smallest (i.e.
top sales) as well as smallest to largest (i.e.
