help with selecting a range of numbers

[chrysti]

I am trying to select the a range of numbers withing a list of numbers. I want to find the max number in the range and then add that with the surrounding numbers (5) in total but I want the other numbers to be high as well, so I can't default to picking the high and two in front and two behind since there is a possibility that the three in front are higher and the one behind is high.

Example:
0,0,5,7,8,10,12,11,9,4,1,0,0
start with the max - 12
select the four highest surrounding numbers in order - 8,10,11,9

is there a way to write a formula that will sum these numbers?

Thanks in advance! Chrysti

 

[SteveO59L]

Have a look at the Large() function

 

[chrysti]

I also need them to stay in order...can there be something added to it that would do that???

Example:
0,0,3,12,9,10,15,11,14,13,9,5,2,0

I would want the range of 10,15,11,14,13 even though there is a number before that which is higher than some in this range, I want the range with th highest numbers around the MAX number.