EXCEL LARGE FUNCTION

Excel LARGE function

LARGE function is used to get the Largest k-th value from the range.

LARGE Function has two required arguments i.e. array, and k

Syntax:

=LARGE(array,k)

Syntax Description:

array argument is used to give the range from which largest value is required

k argument is used to give value for th value i.e. 1^st , 2^nd ,3^rd, 4^th… position from the array argument

Example 1:Excel LARGE function with cell Range:

“Column A” has number values,
“Column B” shows the sample formula applied,
“Column C” shows the value for k argument (position), k-th position that is required,
“Column D” shows the output of the function and,
Explanation is provided in “Column E”

Hope you learnt this Function!

Don’t forget to leave your valuable comments!

If you liked this article and want to learn more similar tricks, please Subscribe and Follow us on Social Media by clicking the below buttons.

EXCEL FUNCTION – RIGHT

ByPradeep Kumar

RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.

Excel Functions

Excel Function – WORKDAY

ByPradeep Kumar

WORKDAY Function in Excel Are you working today? or Do you have Work Off or holiday today? I am asking this question because I am gonna tell you the most commonly used function in Excel…