=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.
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.
In this tutorial you’ll learn how to use the TEXTBEFORE function in Excel to quickly get the text before a specific character or word.In older versions of Excel, this was more difficult. You had to…
Excel Function REPLACE REPLACE function is used to replace the existing text from a specific location in a cell to New Text. REPLACE Function has argument four arguments i.e. old_text, start_num, num_chars and new_text. We need to give the…
Excel has long allowed you to switch data between rows and columns. But turning a whole range of cells into a single column used to be difficult. That has now changed. Microsoft has introduced a…
INT function is used to round down the numeric value to nearest integer. INT Function has one required argument i.e. number.