Excel – LARGE function, returning largest value number k

By Laura

LARGE function points out the largest value number k in a given data arrange, helping you to find your expected value from the rank of that value in the data array.

In Excel, LARGE function is used quite frequently. This function has a simple syntax, but has a very tremendous application. Let’s follow this article from betdownload.com to understand the syntax as well as usage of LARGE function.

HOW TO USE LARGE FUNCTION IN EXCEL, ILLUSTRATION
Syntax: LARGE( array,k)

In which:

- Array: The data array that you want to find the largest value number k, in which

- K: is the rank of the value that you want to search for in the data array.

Arguments are required in LARGE function.

Example: Given a transcript of some students, find out the highest and second highest scores?

Use formula in cell C7:  =LARGE($C$2:$C$6;1)

                                   Cell C8: =LARGE($C$2:$C$6;2)

Result:

The usage of LARGE function to find the largest value number k is simple with several manipulations above. This function is widely used in the work or studying. In addition, you can refer to the usage of other functions in Excel.

 

Related Articles:
Excel – AVERAGEIF function, calculating average with conditions
Excel – FREQUENCY function, counting frequently-appeared values
Excel - LEFT function, for cutting left string
AVERAGEIFS function, calculating average with multiple conditions
Excel – HLOOKUP function - a search function in Excel
Excel - How to use the ConcateNate function to connect character strings in Excel

Comments

Comments

Tags:

large function in excel

,

function returning the kth largest value

,

large function in excel 2003

, large function in excel 2007 large function in excel 2010 large function in excel 2013


Related software
  • K 3D

    K-3D is the software which supports users to create models, 3D animations professionally and easily. With this utility, you can freely design unique 3D animations from the simple to the complex for different aims.

  • Sendago - Send large files via email
  • Free Large Android Icons - Large Android Icons.
  • K Media Center - Listen to karaoke music

Latest update

Copyright BETDOWNLOAD.COM © 2014 - All rights reserved