LARGE Function Dictionary

Function Dictionary Function Examples Function Categories

Values Highest Value 800  =LARGE(C4:C8,1)
120 2nd Highest Value 250  =LARGE(C4:C8,2)
800 3rd Highest Value 120  =LARGE(C4:C8,3)
100 4th Highest Value 120  =LARGE(C4:C8,4)
120 5th Highest Value 100  =LARGE(C4:C8,5)
What Does It Do ?            
This function examines a list of values and picks the value at a user specified position
in the list.
No special formatting is needed.
The following table was used to calculate the top 3 sales figures between Jan, Feb and Mar.
Sales Jan Feb Mar
North £5,000 £6,000 £4,500
South £5,800 £7,000 £3,000
East £3,500 £2,000 £10,000
West £12,000 £4,000 £6,000
  Highest Value £12,000  =LARGE(D24:F27,1)
  2nd Highest Value £10,000  =LARGE(D24:F27,2)
  3rd Highest Value £7,000  =LARGE(D24:F27,3)
Another way to find the Highest and Lowest values would have been to use
the =MAX() and =MIN() functions.
Highest £12,000  =MAX(D24:F27)
Lowest £2,000  =MIN(D24:F27)


Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download