Hello!

I need some help with a seemingly simple, but tricky, task. I need help developing a way to identify local minimums and maximums in a set of relatively noisy data. The data has minimums and maximums that do not have a set periodicity, nor do they have set amplitudes. There may be two data points that share the same value, but one may constitute a maximum or minimum at some time while the other does not at another time. If possible, I would prefer indications through excel functions as opposed to VBA generated indications.

Ideally, I would like to be able to have variable inputs for the following:

Search window (i.e. within 10,20,50 data points, search for the local extrema)
Peak / Trough magnitude (i.e. minimum % of growth / decay (appreciation/depreciation) of magnitude of values)
The peak / trough magnitude can be the same value, for example 3% growth and 3% decline constitute a recognizable event warranting indication of a local extrema event.

So a complete example would be, provide indication for a 3% growth/decay event occurring over a minimum period of 10 data points. I have attached a representative sample of data below as well as here: Data1.xlsx

I can't express how grateful I, and others, would be for any assistance in the resolution of this problem. Thank you for your time.

-AISI