Hi. Have haev a problem im hoping you can help me solve. Its probably not that hard as it could be solved by a while-loop in MatLab, but im not sure how to do it in excel.
Here it is:
I have two columns with data, in one all of the rows has values, and in the second most rows are zero and some have values.
How can i delete the rows that contain zero?

for instance i want this:
1 0
2 1
3 0
4 0
5 1,2
6 0
7 0
8 1,1
9 0
to become this:
2 1
5 1,2
8 1,1

Any thoughts?
thank you.