Delete y-values based on x-values

[JHCJ]

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.

[MrShorty]

My first thought on something like that is to use the built in filter utilities.
the simpler to use autofilter http://www.wikihow.com/Use-AutoFilter-in-MS-Excel
the more complex but more powerful advanced filter: http://www.contextures.com/xladvfilter01.html

[JHCJ]

Thanks for your reply the advanced filter seems to have done the trick!

Much appreciated!

/Jonathan