=LARGE(array,k)
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
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.
Microsoft Excel is a useful tool for analyzing data and conducting statistical research. The program includes numerous functions for performing various statistical calculations. One of the essential measures Excel supports is the weighted average.
In this tutorial, you will learn 3 effective approaches How to Extract First Line in Excel of text. formulas, regex. In data analysis, Excel is a powerful tool that helps make difficult tasks easier. One…
ROW function is used to get the row reference number of the excel worksheet. ROW Function has only one argument i.e. reference,
COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.
Many tasks in Excel require comparing data in different cells. To do this, Excel offers six logical operators, also known as comparison operators. This tutorial will help you understand how these operators work and how to write efficient formulas for data analysis
Microsoft Excel “HOUR, MINUTE, SECOND Functions” are time related functions helps to extract the Hour, Minute or Second from a complete Time.