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