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.
Microsoft Excel “HOUR, MINUTE, SECOND Functions” are time related functions helps to extract the Hour, Minute or Second from a complete Time.
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
RAND AND RANDBETWEEN FUNCTION We have got many instances where we needed to generate a random database or values. “RAND function” is very useful for users who creates random database for various types of working…
An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.
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…
RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.