Greeting all,
I have a bunch of data starts from B14-16000. I want a macro to start from,for example, row 200, then read 300 cells at a time, keeps going until 16000. If the Standard Deviation of these 200 cells is under 0.05 then find the average and paste it on Column M, start from M1.
If you plot it out by "XY scatter", it will look like about 10 mini water falls, depends on the data given, sometimes goes from left to right and vice versa.(probably not going to affect the code, just want to give you an idea of how it looks like) So, basically, I want to find the average in the "flat" region. What I don't want is when the data changes significantly.
I am not sure if it is doable. Hopefully, after the explaination, it is.
Thanks in advance!!! really appreciate your help!
Jason
I have a bunch of data starts from B14-16000. I want a macro to start from,for example, row 200, then read 300 cells at a time, keeps going until 16000. If the Standard Deviation of these 200 cells is under 0.05 then find the average and paste it on Column M, start from M1.
If you plot it out by "XY scatter", it will look like about 10 mini water falls, depends on the data given, sometimes goes from left to right and vice versa.(probably not going to affect the code, just want to give you an idea of how it looks like) So, basically, I want to find the average in the "flat" region. What I don't want is when the data changes significantly.
I am not sure if it is doable. Hopefully, after the explaination, it is.
Thanks in advance!!! really appreciate your help!
Jason
Last edited:
