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:
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
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