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

Excel VBA Master Tool Kit
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. 1st , 2nd ,3rd, 4th … 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”
Learn Excel Large Function

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.

Recommended Articles

Similar Posts

excel nested if statement

Excel Nested IF statement: examples, best practices and alternatives

BySumit Shrimal

This guide shows how to use the nested IF function in Excel to check several conditions. You will also learn about other functions that can be to use than a nested formula.
When you want to make decisions in Excel, you often use an IF formula. It checks if something is true, then gives one result if it is and another result if it isn’t. If you need to check more than one thing, you can put many IFs inside each other.
Although using multiple IFs is common, it’s not the only way to check several conditions in Excel. This guide will introduce you to some easier and useful alternatives.

Leave a Reply

Your email address will not be published. Required fields are marked *

Excel VBA Master Tool Kit