extracting threhold values from a data set

Dear all,

I have a data set containing multiple verticle ground reaction force curves recorded from a running session on a treadmill which has strain guages that measure the vGRF for each step.

I will then be dividing the vGRF data by body weight to get the acceleration of the curve

from that I will then be looking at the impulse etc.

what I would like to do is develop a code/script or formula that will pick out data points that are above a certain threshold (~3m/s/s) in the acceleration curve data and then put that data into a seperate column. I am a complete beginner with VBA and my excel skills are very basic so any help and advice on where to start with this would be much appreciated.

I have attached some sample data to this post to help with the explanation of what I am trying to achieve.

kind regards

Will vGRF_example_data_excel_forum.xlsx

vGRF_example_data_excel_forum.xlsx

Hi,

thank you for the reply. I have attached the example data again. In the acceleration column (column C) i have highlighted all the cells green that have a value less than 3m/s/s which is my threshold cut off. I have then shown a scatter plot of the data that I would like to be left with in column D. I hope this is clearer

best wishes

will

Hi,

thank you so much, yes this is perfect

will