Search function from a prescribed range

[gannon_w]

So the data attached is someone hopping and the forces against the ground (1000 Hz sample rate). They hop every 2 seconds or based on our sampling rate there's a hop within every 2000 data points. I wrote a function that could find the max value per hop (yellow) which happens during the landing. Then when dragged down it finds the max for every hop. Now I want to find the pushoff max force (Blue Arrow). Notice the values go to 0 after the Blue arrow?...well the max push force should happen within 500 samples behind that 0. So I need to find the zero then search for the max of the range of 500 before that zero. Does that make sense? :D

[JEC.]

I assume that you have an old Excel version, since you use offset, right?
Anyways, put this in D1 and pull down

Please Login or Register  to view this content.