Theory:
=LARGE(Range,Number)
Example:
=Large(A2:A9,2)
The Large function displays the largest or highest value from a range based on the number value written after the range reference. The number 2 in the formula above states that the formula should display the 2nd highest (or largest) value from range A2 to A9. A number 1 would denote to display the 1st highest value. The number 3 would denote to display the 3rd highest value and so on.
=LARGE(Range,Number)
Example:
=Large(A2:A9,2)
The Large function displays the largest or highest value from a range based on the number value written after the range reference. The number 2 in the formula above states that the formula should display the 2nd highest (or largest) value from range A2 to A9. A number 1 would denote to display the 1st highest value. The number 3 would denote to display the 3rd highest value and so on.
0 comments:
Post a Comment