Advanced Filter, nested =IF function, or possibly some other tricker *please help*

Hello:

I would appreciate any help I can get at this point. I believe that what I need to do is a nested =If Function in order to do what I want but I have never done that. I am also sure there are other ways to accomplish my goal but Ill let you be the experts.

Simplified:

I am trying to return a list that has unsorted rows (this list is being compiled by use of a formula)

3 1 1 2

2 1 1 3

0 0 0 0

1 1 1 1

3 1 1 2

2 1 1 3

0 0 0 0

In a new sheet I would like to return all rows that do not contain 0 in the first column.

I would like this to be done through the use of a formula since sorting by the first row would unsort the other columns (may not make sense with my example but take my word for it.) So far I have
=IF(Sheet1!C15>0,Sheet1!C15,Keyword1!C16)

The Problem is each time this file is used the
3 1 1 2

2 1 1 3

0 0 0 0

Will be different each time with different amount of rows containing 0 0 0 0.

This may make no sense at all and if it does not... sorry but short of attaching the 20mb file Im lost for ideas.

I appreciate any help.

Thanks,

mmarshall

Hi

If your data is in sheet1!A1:D13 then on sheet2 array enter the formula
A1:=IF(ROW()>COUNTIF(Sheet1!$A$1:$A$13,">0"),"",INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$A$1:$A$13>0,ROW(Sheet1!$A$1:$A$13),""),ROW())))
To array enter, hold down the shift and ctrl keys, then press enter. You will find that the formula will be enclosed in {}.

Copy from A1 across to D1. Then copy A1:D1 down to row 13.

HTH

rylo