=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.
COUNTA function is used to get the total count of Any-value or Non-Blanks in range. COUNTA Function has one required and optional argument: value1, value2
Generate Random Numbers in Excel Using RAND We have got many instances where we needed to generate a random database or values. Rand function is very useful for the users who creates random database for…
MID function is used for extracting the mid characters from the available string. The output of the function returns the extracted characters in new cell.
UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.
Excel Function ISERROR Microsoft Excel “ISERROR Function” is a Logical Function and it is used to check if cell contains any “ERROR”. “ISERROR Function” is used as a test to validate if cell contains any…
LOWER function is used for changing the format of any text or string to LOWER case.