Find MAX in range and average the values in adjacent 25 cells

[Pedro's PhD]

Hey everyone,

I have data in cell range A1031:A1331. I need to find the maximum value within this range and then compute the combined average from the 25 cells before the maximum value and the 25 cells after the maximum value.

For example: If the MAX was in cell A1150, then I would need the average of A1125:A1175

Thanks..... Pedro

 

[Pedro's PhD]

Hi Alvin,

Thanks for this, really appreciate it. The reason for the odd design is that it is used to find a peak value/ spike within an EMG trace, and then the average from a 50ms window centered around the peak value. This data is copied into excel after undergoing previous analysis, which allows me to be sure the range will always be the same.

As for the data in the bottom rows, this is because there are baseline values in the previous cells.

The formulae you have provided will work excellently for me!

Thanks.... Pedro