My simplified data set looks like this: ( the real one is much more confusing)
Time Ch. 16
1 1
2 0
3 2
4 1
5 6
6 7
7 8
8 7
9 5
10 0
I know that the max is 8, and the minimum is really 0. But what I want my macro to do. Is determine that the data goes up then comes down again before hitting the max point. Is there a way to determine that 2 is a max point, and to take the values in between 2 and 8 in order to find the minimum point, 1.
Eventually I would like to use the minimum, 1, in a formula later. As long as I can get the macro to identify it, I can figure it out from there though.
Thanks for any help.
Time Ch. 16
1 1
2 0
3 2
4 1
5 6
6 7
7 8
8 7
9 5
10 0
I know that the max is 8, and the minimum is really 0. But what I want my macro to do. Is determine that the data goes up then comes down again before hitting the max point. Is there a way to determine that 2 is a max point, and to take the values in between 2 and 8 in order to find the minimum point, 1.
Eventually I would like to use the minimum, 1, in a formula later. As long as I can get the macro to identify it, I can figure it out from there though.
Thanks for any help.