+ Reply to Thread
Results 1 to 4 of 4

Condition formula for finding the nth largest value based upon the number cell entries

  1. #1
    Registered User
    Join Date
    12-10-2014
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    5

    Condition formula for finding the nth largest value based upon the number cell entries

    Appreciate any assistance with developing a formula that identifies the third largest value if there are 9 or 10 cell values in a cell range, second largest value if there are 6, 7 or 8 cell values in a cell range and the largest value if there 1,2,3,4 or 5 cell values in cell range. Here is a simplified example:

    There will always be 10 cells in a cell range. The 10 cells may have one to ten values reflected in the cell range. If 9 to 10 of the cells contain a value the formula needs to return the third largest value. If 6 to 8 cells contain a value then the formula needs to return the second largest value and finally if 1 to 5 cells contain a value then the formula needs to return the largest value.

    Column A

    87
    37
    90
    99
    93
    57
    91
    51
    92
    103

    In this example all ten cells in the cell range have values therefore want to know the third largest value, which in this case is 93. If only eight of the cells had values (assume the first two cells are empty) then want to know the second largest value, or in this example 99.

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Condition formula for finding the nth largest value based upon the number cell entries

    Hi,

    Use this formula :

    Please Login or Register  to view this content.
    Regards
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  3. #3
    Registered User
    Join Date
    12-10-2014
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Condition formula for finding the nth largest value based upon the number cell entries

    Thanks, works great!

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Condition formula for finding the nth largest value based upon the number cell entries

    You are welcome. Many thanks for the reputation point.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] finding a corresponding cell based on a condition
    By orajesh in forum Excel General
    Replies: 3
    Last Post: 09-23-2014, 09:51 AM
  2. [SOLVED] Finding the largest number based on criteria
    By imerial in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2013, 03:19 PM
  3. Finding and Deleting Rows based on Formula entries
    By BehrBrew in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2012, 06:01 PM
  4. Replies: 10
    Last Post: 12-17-2009, 02:00 AM
  5. Finding the Largest Number, based on two criteria
    By BigH in forum Excel General
    Replies: 1
    Last Post: 02-08-2006, 04:55 PM

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