Eliminating zeros, null values and negatives in a column

[jannie]

I have columns of number volumes for oil, water and gas. Example: column A may have 100 numbers in it. Let's say: 10.00, 30.00 .02, 0,-.05, 1000.00, 2.00, 0, nothing, nothing, 0, 1.00 and so on. It can be any volume. What I want is a formula that removes all the zeros, all the nulls and any negative numbers. And puts the numbers in order eliminating the ones I don't want. Example it would end up like this (using numbers shown earlier). 10.00, 30,00, .02, 1000.00, 2.00, 1.00. Does anyone have any ideas on how to do this?

[Catalin.B]

You just have to use a filter: go to Data-Filter-Number filter-Greater than...and enter value 0, to sort only values greater than 0..
Good Luck!