+ Reply to Thread
Results 1 to 3 of 3

Input to equal the largest value from list above

  1. #1
    Registered User
    Join Date
    10-26-2012
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    34

    Input to equal the largest value from list above

    Hello,
    I have a list of input values that will vary depending upon inputs from other cells. I need the cell beneath this
    list to show the largest of the cell values. The trick here, is that it will never be the same cell that has the
    largest value. I am wondering if there is a formula for this?

    To sumarise, cells E10 to E15, will all have a value input of differing numbers, E16 needs to reflect the figure
    from E10 to E15 which is of the highest value. Is this possible?

    Thank you in advance
    Geoff

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Input to equal the largest value from list above

    maybe this?

    =large(E10:E15,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
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Input to equal the largest value from list above

    Happy to help and thanks for the feedback

+ 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] Is it possible to create two input cells that equal each other?
    By MadMax3D in forum Excel General
    Replies: 4
    Last Post: 11-06-2012, 11:05 AM
  2. Top 5 largest results from list
    By LiLi1 in forum Excel General
    Replies: 9
    Last Post: 08-05-2010, 05:03 PM
  3. Permuation of 4 digits but not equal to input
    By yeksm in forum Excel General
    Replies: 2
    Last Post: 01-07-2008, 05:20 AM
  4. Finding the 3rd largest number in a list
    By Simon Jefford in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. Finding the 3rd largest number in a list
    By Simon Jefford in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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