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
Bookmarks