{"id":326,"date":"2019-04-04T14:39:42","date_gmt":"2019-04-04T11:39:42","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=326"},"modified":"2019-04-04T16:19:15","modified_gmt":"2019-04-04T13:19:15","slug":"the-large-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-large-function\/","title":{"rendered":"The LARGE function"},"content":{"rendered":"\n

In statistics the MAX<\/a><\/strong> function is not enough. The need to calculate, for example, the third largest value of a range of cells, is very common. <\/p>\n\n\n\n

This is what the LARGE<\/strong> function calculates. It returns the n-th <\/strong>largest value from an array of numeric values. <\/p>\n\n\n\n

We have put together a Tutorial<\/a><\/strong> on how to use the functions LARGE<\/strong> and SMALL<\/a><\/strong>.<\/p>\n\n\n\n

The syntax of the LARGE function is the following<\/p>\n\n\n\n

LARGE(array, n)<\/strong><\/p>array<\/strong>: the range of data for which you want to determine the n-th<\/strong> largest value
n<\/strong>: it will determine the position from the largest value in the array<\/strong> <\/cite><\/blockquote>\n\n\n\n

<\/div>\n\n\n\n

If the array is empty a #NUM!<\/strong> error value is returned.<\/p>\n\n\n\n

If the n value is greater than the number of data in the array or if it less than or equal to zero then a #NUM! <\/strong>error value is returned.<\/p>\n\n\n\n

The LARGE(array, 1) <\/strong>returns the maximum number in the array, so it is equal to the MAX(array)<\/strong> function.<\/p>\n\n\n\n

If the total number of data points in the array are k then the function LARGE(array, k) <\/strong>returns the minimum value of the array so it is equal with the MIN(array) <\/strong>function.<\/p>\n\n\n\n\n

<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here are some examples of the possible uses of LARGE:<\/strong><\/p>\n\n\n\n

<\/p>\n\n\n\n

In the G5<\/strong> cell of the SALES<\/strong> sheet, calculate the sum of the three largest<\/strong> values of column E<\/strong>. You will have to use an array constant.<\/p>\n\n\n\n

\n