Results 1 to 8 of 8

Find a value in a limit where its difference from an array of values is maximum

Threaded View

  1. #1
    Registered User
    Join Date
    09-30-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Find a value in a limit where its difference from an array of values is maximum

    I have a pre-defined limit, lets say, lower limit is 63 and upper limit is 68.

    I have an array of values, lets say

    65.25
    67.32
    68.34
    64.5
    62.5
    64.25
    67.5

    I want to use an excel function or a combination of functions to find out a value in the range 63 to 68 where its difference from the next lower value in the above mentioned array list is maximum. For this example, I would like to have the value as 67.32 since its difference with the next lower value (65.25) is 67.32 - 65.25 = 1.93 (maximum for the range 63 to 68).

    What excel function should I use? Please help me.

    I am attaching a sample file along.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. to compare among a set of values and to find the maximum among them
    By arya ravi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2013, 06:52 AM
  2. Replies: 2
    Last Post: 06-26-2012, 03:13 AM
  3. Using an array to find a maximum value
    By andrewc in forum Excel General
    Replies: 2
    Last Post: 05-09-2008, 09:17 AM
  4. Maximum UBound Array Limit
    By Tarball in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2007, 10:10 AM
  5. Replies: 5
    Last Post: 05-13-2005, 01:06 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