---
title: "LARGE function in Excel"  
description: "LARGE function in Excel"  
author: "AVADHESH PATEL"  
published: 2013-03-27  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/1170/large-function-in-excel  
category: "excel"  
tags: ["excel"]  
reading_time: 1 minute  

---

# LARGE function in Excel

In this [article](https://yourviews.mindstick.com/view/81489/kashmir-now-after-an-year-of-abrogation-of-article-370) I have described how to used LARGE [function](https://www.mindstick.com/articles/43970/purchase-suitable-wedding-dresses-for-your-wedding-function) in [Excel Sheet](https://www.mindstick.com/forum/23040/to-import-excel-sheet-into-sql-database). LARGE function returns the k-th [largest value](https://www.mindstick.com/forum/156802/write-a-program-that-take-n-integer-number-as-input-and-display-the-second-largest-value) in a data set. You can use this function to [select](https://www.mindstick.com/forum/34066/use-select-operator-in-linq) a value based on its [relative](https://answers.mindstick.com/qa/105067/how-to-trade-with-the-relative-vigor-index) standing. For example, you can use LARGE to return the highest, runner-up, or third-place score.\

##### Syntax

LARGE([array](https://www.mindstick.com/articles/14/array),k)

Array - is the array or [range](https://yourviews.mindstick.com/view/87860/does-biden-wants-nuclear-war-provokes-russia-by-long-range-missiles) of data for which you want to determine the k-th largest value.

K - is the position (from the largest) in the array or cell range of data to return.

##### Note:

If array is empty, LARGE returns the #NUM! error value.

If k ≤ 0 or if k is greater than the number of data points, LARGE returns the #NUM! error value.

If n is the number of data points in a range, then LARGE(array,1) returns the largest value, and LARGE(array,n) returns the [smallest](https://yourviews.mindstick.com/view/81880/royal-families-of-world-s-smallest-islands-do-fishing) value.

##### For example:

![LARGE function in Excel](https://www.mindstick.com/mindstickarticle/f74add2f-c7a6-4936-8dbb-6edd3885e21e/images/fa0a7ed1-b122-402c-919e-e0d18cb8d19d.png)

---

Original Source: https://www.mindstick.com/articles/1170/large-function-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.