I have a large set of data, and it has several peaks over time. Essentially I would like to find the different max points, and their time. After distinguishing the maximum points, I would like to take a period of time between the first and second maximum point and find the minimum point.
With the minimum point, I want to use that to subtract from each data point.
Here's a simplified version of what i am asking.
1 -1
2 1
3 0
4 -5
5 -4
6 -3
7 -2
8 7
9 5
10 0
11 -3
12 0
The max pts would be 1 and 7, the lowest point between this period is -5.
Then the third colum would take each value in column 2 and subtract -5 from it.
Sorry it sounds a little confusing, but i feel finding multiple maxiums must be possible on excel. Thanks for any help!
With the minimum point, I want to use that to subtract from each data point.
Here's a simplified version of what i am asking.
1 -1
2 1
3 0
4 -5
5 -4
6 -3
7 -2
8 7
9 5
10 0
11 -3
12 0
The max pts would be 1 and 7, the lowest point between this period is -5.
Then the third colum would take each value in column 2 and subtract -5 from it.
Sorry it sounds a little confusing, but i feel finding multiple maxiums must be possible on excel. Thanks for any help!