Results 1 to 3 of 3

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

This is a discussion on Formula to find SECOND largest number in a group... within the Excel Questions forums, part of the Question Forums category; I have a range of 10 numbers that is part of 9 categories. The first range is (D:4,D14). I have ...

  1. #1
    New Member
    Join Date
    Apr 2003
    Posts
    5

    Default 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. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,949

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

    Use LARGE

    =LARGE(D4:D14, 2)
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member
    Join Date
    Apr 2003
    Posts
    5

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

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

    God bless...
    Todd Sleaving

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com