MAX help?

ecarney14

New Member
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.

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Hi,

A formula based approach..
Book1
ABCD
2111
320
432
541
656
767
878
987
1095
11100
Sheet2

Formulain C2,

=MIN(INDEX(B2:B11,MATCH(0,B2:B11,0)+1):INDEX(B2:B11,MATCH(0,INDEX(B2:B11,MATCH(0,B2:B11,0)+1):INDEX(B2:B11,MATCH(9.999999999E+307,B2:B11)),0)-1))

HTH

wow. how did you come up with that. i am going to check and see if it works for other data. but whz the 9.999e307?

thanks though

Replies
4
Views
236
Replies
2
Views
166
Replies
3
Views
389
Replies
13
Views
326
Replies
2
Views
188

1,218,899
Messages
6,145,098
Members
450,590
Latest member
Naneng

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back