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
=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.
Excel has built-in options to make graphs, it doesn’t have a heat map feature. However, you can quickly and easily create a heat map in Excel using conditional formatting.
SUBSTITUTE function is used to substitute the existing old text to new text.
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
Microsoft Excel “ISBLANK Function” is a Logical Function and it is used to check if cell in question is “BLANK OR NON-BLANK”. “ISBLANK Function” is used as a test to validate if cell contains any…
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
This guide will show you quick and easy methods to find the number of days between dates in Excel.
Do you need to know how many days are between two dates? Maybe you want to find out the days between today and a date in the past or future, or just count the working days between two dates? Whatever you need, one of the examples below will help you find the solution