Hi there!

In one of my school projects i am performing a series of measurements which adds up to about 20 000 datapoints.
Instead of going through 20000 datapoints manually there should be a way to automate the things i want to do.

Some of the datapoints are really bad and should be removed, these values are pure abnormalities and should not be taken into consideration. I want to delete decimal values smaller than a certain integer if they are within a specified x-range.

Forum post.PNG

For example: Delete all y values less or equal to 21 in the x region -> 42781,4 < x < 42781,45

Hope someone knows of a way to do this!

Best Regards Jonathan


The assignment is not to build a function in excel that does what i'm asking for. The assignment is the measurement it self so by helping me with this you would not help me to cheat.