+ Reply to Thread
Results 1 to 4 of 4

find value which is greater than in a range of cells and return the greater value

  1. #1
    Registered User
    Join Date
    12-19-2012
    Location
    india
    MS-Off Ver
    MS 365
    Posts
    28

    find value which is greater than in a range of cells and return the greater value

    hi freinds,

    i have a problem, i am new to excel formulas i want to find value which is next higher than d13 cell value in a range d3:d8 and return the higher value to a cell


    this will be helpful for me if you solve the problem thanks in advance


    thanking you

    green

    Calc.xlsx
    Last edited by green369; 06-11-2015 at 04:08 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,434

    Re: find value which is greater than in a range of cells and return the greater value

    See if this is what you want?
    =INDEX($D$3:$D$8,MATCH($D$13,$D$3:$D$8,-1))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    12-19-2012
    Location
    india
    MS-Off Ver
    MS 365
    Posts
    28

    Re: find value which is greater than in a range of cells and return the greater value

    hi

    Fdibbins

    ihave seen your reply and used the formula how i can edit the formula to use for other cell values that is d14, d15,d16 ..........etc

    thanks in advance

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,434

    Re: find value which is greater than in a range of cells and return the greater value

    Not sure what you mean? Something like this?

    =INDEX($D$3:$D$8,MATCH($D13,$D$3:$D$8,-1))

+ 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] Find first value that is greater than X, and return value in another column
    By rabidchild in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2014, 10:29 AM
  2. If anyone of these cells are greater than 10 return a yes, if not no
    By Jr66 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-09-2013, 06:42 PM
  3. Replies: 9
    Last Post: 10-26-2012, 12:52 PM
  4. Associate/Find Nos and Return Equal/Greater
    By Celticshadow in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-16-2011, 07:24 PM
  5. return only cells with values greater than 0
    By Sprain Brain in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-02-2010, 05:28 AM

Tags for this Thread

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