The LARGE() function returns an argument in the nth position of an array of values arranged in decending order of thier value. The syntax for the function is =SMALL(array, nth_position). The argument "array" can be numerical values, a reference to a range of cells or a named range which you want to analyze. The "n_position" is the relative position you wish to find. The LARGE function can asses the value of elements in the array, organize them into list of data values in decending order (from the largest value to the the smallest) then isolate and return the nth term in the listed. For example: LARGE({6,8,2,7,3}, 2) = 7 as the array of values {6,8,2,7,3} when arranged in decending order becomes {8,7,6,3,2} and the 2nd element is the number 7.

How to use the LARGE() function: Type " =LARGE( " Enter the coordinates for the range of values in the "array" e.g. "A2:A10". Type a comma. Enter the "nth_position" you want to find e.g."2". Type")" then press the "Enter" key.

The difference between RANK, LARGE and SMAL functions The LARGE function orders a list of values from largest to smallest, the SMALL function orders the values from smallest to largest. However the RANK function can returns the position number of a value in the list of data values in either decending or acending order depending on the parameters set by the user. Note: The LARGE function ignores non numeric values in referenced in the array. Additionally if the nth_position entered into the function is larger than the number of elements in the array the function will return a #NUM! error. Ranking Multiple values.