VBA code that locate and store "local" max. and min. values in a column and store the time associated corresponding to that value...........

[NCO_1969]

Hi Excel / VBA community

I have not been doing any VBA programming for more than ca. 10 to 15years, so I have forgot big deal
Now I have a problem of data processing large amount of data, that I get in *.xlsx - file format.

The file has the following content / layout:

Time step	A - response #1	B - response #2	C - response #3	D - response #4
0.001	Data ***. to response #1	Data ***. to response #2	Data ***. to response #3	Data ***. to response #4
0.002	Data ***. to response #1	Data ***. to response #2	Data ***. to response #3	Data ***. to response #4
0.003	Data ***. to response #1	Data ***. to response #2	Data ***. to response #3	Data ***. to response #4
continues down ca. 33.000 lines	continues down ca. 33.000 lines	continues down ca. 33.000 lines	continues down ca. 33.000 lines	continues down ca. 33.000 lines

I would like some help with some code how to identify local max. & min. in the different columns (A, B, C and C), each time a local min. or max. value is identified in a column the associated time should be stored, so the time between max. and min. values occur can be calculated, (for each response column).

Hope there are some in here with some good proposals.

KR - NCO

 

[6StringJazzer]

The VBA is very difficult to read unformatted. I recommend using the VBA code tags next time.

 

[NCO_1969]

Hi again 6StringJazzer

I thought you could just copy paste the hole thing into a new spread sheet, vupti, then you will see it correct formatted etc.
And see what the VBA does in the same spread sheet, by running the VBA ?

KR - Niels O.

 

[6StringJazzer]

I will give it a try when I can get the time.