You might one day come across a situation where you might be required to find the 1st, 2nd and 3rd largest number from a given set of data.

Wondering how to do it?

No problem, we can use excel’s Large function!!!

Let us see how to use it in detail…

1. What is a LARGE Function?

2. What is the Syntax?

3. How to use it with an example?

*1. What is a LARGE Function?*

*1. What is a LARGE Function?*

The LARGE function can be used to find the nth largest number from a given set of range.

*2. What is the Syntax?*

*2. What is the Syntax?*

=**LARGE(Array, N)**

**Array =**Array represents the data set from which you want to retrieve the largest number.**N =**N represents the specifies the position from the largest value in descending order.

*Note :*

- #VALUE! error – Occurs when the supplied N argument is non-numeric.
- #NUM error – Occurs when:
- The array provided is empty.
- When the value of the N argument is less than 1 or greater than the number of values in the given array.
- When the range contains an error in it.

*3. How to use it with an example?*

*3. How to use it with an example?*

For a second let’s assume that you are an organizer for a lottery event!!!

As you came home and sat on the couch, your little kid asked you about the prizes.

Shit-Shit-Shit…!!!

With the busy workday, you just forgot the prizes in sequence.

Why not make it a little interesting for your kid, ask him to enter the position(Number) in sequence and allow him to find the prize money… 🙂

*****1st Prize*****

### ***2nd Prize***

### ***3rd Prize***

*Hope it has helped you…*