Extract essence of a table

[magnusm]

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.

[mmmarks]

try dis,
[code]
Sub delrows()

Dim rcntB As Long
rcntB = Worksheets("sheet1").Range("B" & Rows.Count).End(xlUp).Row
For i = rcntB To 1 Step -1
If Cells(i, 2).Value = 0 Then
Cells(i, 2).EntireRow.Delete
End If

Next i
End Sub
[\code]

[Pepe Le Mokko]

Use XL's filter on 0 values and delete the rows - Same thing with a Macro: a loop is inefficient use the filter

[magnusm]

filter worked. set a filter, then copied the new order. thanks