LARGE

Returns the $n^{th}$ largest value in a list of numbers.

Syntax:

LARGE(numberlist, n)

returns the $n^{th}$ largest number within the (unordered) range or array of numbers numberlist.

Example:

LARGE(B1:B4, 3)

where cells B1, B2, B3, B4 contain 4, 7, 5,and 8, returns 5. The highest number is 8, then 7, then in third place 5.

Using the LARGE Function:

The LARGE function allows you to find the k-th largest value in a dataset. Its syntax is typically:

LARGE(array, k)

• array: The range of cells containing the numbers you want to analyze (in this case, the Sales column).
• k: The position from the largest you want to find. For example, 1 for the largest, 2 for the second largest, and so on.

Examples with the Data:

1. Finding the top salesperson's sales:
2. • To find the highest sales figure, you would use k=1.
   • Formula: LARGE(B1:B7, 1)
   • Result: 180,000 (Eva's sales)
2. Finding the second-highest sales figure:
3. • To find the sales of the second-best performer, you would use k=2.
   • Formula: LARGE(B1:B7, 2)
   • Result: 175,000 (Charlie's sales)
3. Finding the third-highest sales figure:
4. • To find the third-highest value in the list, you would use k=3.
   • Formula: LARGE(B1:B7, 3)
   • Result: 160,000 (Grace's sales)

Summary:

The LARGE function is a powerful tool for quickly extracting specific values from a dataset without needing to manually sort the entire column. In this sales scenario, it helps the manager efficiently identify and analyze the top performers based on their sales figures.