Thanks:  0
Likes:  0

# Thread: Formula to find SECOND largest number in a group...

1. ## Formula to find SECOND largest number in a group...

I have a range of 10 numbers that is part of 9 categories.

The first range is (D:4,D14). I have the Max number in a hidden cell, but what I'd like to do, is figure a way to find the "NEXT" number in that series in order to creat a formula to subtract the MAX from the NEXT MAX.

The problem is the cells these numbers are in, can change weekly affected by the other 9 categories.

So basically I'd like to know how I can find the 2nd highest number in a series of ten cells that are dynamic?

Thanks
Todd

2. ## Re: Formula to find SECOND largest number in a group...

Use LARGE

=LARGE(D4:D14, 2)

3. ## Re: Formula to find SECOND largest number in a group...

Thank you so much for you lightning fast response...

God bless...
Todd Sleaving

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•