Remove values lower than 70 in column

Hey I need help.

The data from an experiment was imported in the wrong way for some reason. The problem is this:
98,7181
98,7134
9,8705
98,6985
98,6932
98,6855
9,8678
98,6727
98,6644
9,8657
98,6516
98,6433
98,6365

As you can see, some of the data is 10 times lower than it should be. The 98 means 98 weight % from a sample.
Is it possible to remove all data which is lower than 70 from a column?
There are 5500 numbers and 6 files. Can’t do it by hand :P

Frederik.

Put this macro in each file
Selet range you want to use it (whole column or just some cells)
And run macro.

Change ' by desired result

Please Login or Register  to view this content.

The Macro worked ! Thank you

Great help.

Another question. If I want to remove all values equal to zero?

Another macro :P

Thanks

Above should do that too (since 0 is less than 70).
but here:

Please Login or Register  to view this content.

It's for some other values. I also have negative values.

But thank you for the macro

Okay. My problem again is this.

I am making a differentiation of the values. It is a weight vs temperatur plot.

But a lot of the x-values (temperatur) are the same.

And because i am doing (y2-y1)/(x2-x1) and a lot of times x2 = x1 I divide by zero. Soo how do I remove all the values where x2 = x1?

I got the mistake 'type mismatch' for the macro.

How do I remove 'divide by zero error'

Looks like this:

#DIVISION/0!
#DIVISION/0!
#DIVISION/0!
#DIVISION/0!
#DIVISION/0!
-0,010741667
-0,011022059
-0,011022059
-0,011022059
-0,011022059
-0,011022059
#DIVISION/0!
#DIVISION/0!
#DIVISION/0!
#DIVISION/0!
#DIVISION/0!
#DIVISION/0!
#DIVISION/0!

I only want the numbers

Frederik.

Originally Posted by Crooza

zbor

Just for info and this might not affect the OP but when I ran your macro it didn't work for consecutive zeros in the column. I suspect the moving the cells up after the deletion means it skips a row so if there are two zeros or more it will delete the first, move the rows up one (ie the same row number as it just deleted) then move to the next row, hence skipping one row in the process.

Thx for notify.
Then it should go with for loop from last row to 1 with Step -1.