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 ?

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. 


Example

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

Popular posts from this blog

FREE MICROSOFT EXCEL TUTORIAL / Learn free online Microsoft excel

Today Formula in Microsoft excel