Large Formula in Microsoft excel
LARGE
Check below example and try to use in excel in real time for
better understanding
Blue text start with "=" is the formula we used
LARGE FORMULA |
What Does It Do ?
Example
This function examines a list of values and picks the value at a user specified position in the list.
Syntax
=LARGE(ListOfNumbersToExamine,PositionToPickFrom)
Formatting
No special formatting is needed.
The following table was used to calculate the top 3 sales figures between Jan, Feb and Mar.
Note
Another way to find the Highest and Lowest values would have been to use the =MAX() and =MIN() functions.
Comments
Post a Comment