=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.
SUM Function in Excel Excel is a mathematical spreadsheet where you can perform multiple calculations with the help of Excel Formulas. These are automated formulas which refreshes automatically once you refresh your data in a…
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.
SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.
Excel Function SUBTOTAL Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use…
Discover free videos and tutorials to master Excel formulas and functions. Practice directly in our Online Excel Practice Files without downloading anything. Have questions? Drop them in the comments. Let’s begin! Basic Excel Formulas and…