+ Reply to Thread
Results 1 to 3 of 3

Finding next highest number in a range

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    21

    Finding next highest number in a range

    I have range EF5:EF130
    I have formulas in place to find highest in section EF5:EF30, EF31:EF60 and EF61:EF90
    I need to be able to find the next highest number in EF5:EF130 that IS NOT the same as the above 3.

    Example:
    Points Awarded to all teams is in EF5:EF130
    Cell EE194 is highest points in section EF5:EF30
    Cell EE195 is highest points in section EF31:EF60
    Cell EE196 is highest points in section EF61:EF90
    Cell EE197 is next highest points in range EF5:EF130 but cannot be the same as the first three

    I'm stuck -- any help would be much appreciated.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Finding next highest number in a range

    Hi cara13xxi,

    I need to be able to find the next highest number in EF5:EF130
    you can use Max function as =max(ef5:ef130), or I m missing something here.. is there any dynamic range issue? can u share a example workbook ? thanks.

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,593

    Re: Finding next highest number in a range

    In cell EE197:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    This is an array formula, you have to enter it with Ctrl+Shift+Enter.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1