=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.
In this guide, you will learn how to use the NPV function in Excel to calculate the net present value of an investment and how to avoid common mistakes when using NPV in Excel.
Microsoft Excel “NOW” function is used to get the current Date and Time. It is very useful function and can be used in many ways.
WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7
MATCH function performs lookup for a value in a range and returns its position sequence number as output. It has two required and one optional arguments
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.
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.