Results 1 to 6 of 6

Return 4th highest number not in list.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Return 4th highest number not in list.

    From a given list of numbers I want to return the 4th highest number that is not in the list.

    If a given list is 1, 2, 3 then the next highest number is 4 but if the list were 1, 6, 3 the 4th highest number not listed is 2. I'm not sure how to accomplish this. A list of 1, 2, 7 would return 3.

    Jim O
    Last edited by JO505; 08-03-2015 at 04:26 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How2 find number in range and return that number or if doesn't exist then the next highest
    By Crawfinator1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-06-2014, 08:52 AM
  2. [SOLVED] Return the highest number from more than 30 fields
    By DWSchuetz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2013, 08:36 PM
  3. Return number with highest frequency count
    By Archibald_SM in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2011, 06:14 PM
  4. Return highest number with date
    By ClearConcept in forum Excel General
    Replies: 2
    Last Post: 10-09-2009, 12:05 PM
  5. Return based on highest number in row
    By jillteresa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2009, 01:43 PM
  6. Return 3rd Highest Value from Unsorted List
    By jpopovaclark in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2007, 05:55 PM
  7. [SOLVED] choose the highest value in a row and return column number
    By jlburke4 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-15-2005, 02:50 AM

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