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.
Bookmarks