Hello everyone,
I have here an Excel spreadsheet that I really would like some help. As you can see in the attached file, I have starting in column B3 to B848 several values that represents the height of a wave.
What I would like is a macro that can read the higher and lowest values of a wave and then write it down to column E. I will do an example:
B E
0,02 0,02
0,14 0,26
0,21 -5,56
0,24 ....
0,26
0,25
0,23
0,17
0,07
-0,12
-0,40
-0,78
-1,24
-1,75
-2,28
-2,80
-3,31
-3,79
-4,23
-4,66
-5,03
-5,31
-5,50
-5,56
...
As you can see, the macro would read column B and search for the higher value, write it down to column E, then search for the minimum value before it gets bigger, and then write it on column E, then would search for the higher value and write it down again to column E.. And do this until the end of column B.
With this I could see the height of all the waves in this data.
Please if someone did not understood correctly please say so, I will try to explain better. Thank you
help.xlsx
Bookmarks