=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.
The tutorial demonstrates how to find a date any number of days before or after today, counting either all days or only business days.
Watch: How to use WEEKNUM Function in Excel? What is WEEKNUM Function? The WEEKNUM function in Excel returns the week number of a given date. It is a DATE and TIME function that can be…
SMALL function is used to get the Smallest k-th value from the range.
SMALL Function has two required arguments i.e. array, and k
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
Discover an incredibly easy way to insert a picture into a cell using the IMAGE function! For years, Microsoft Excel users had to go through a long and tricky process to add pictures to worksheets….