Data sorting using two column with same criteria

[dandavis1]

Please see attached.

I have tried using the advanced auto filter but im having no joy.

In columns G and H there are numbers ranging from 0-2, i want to be able to sort both columns with same criteria so that if there is a number greater than 0 in either column than all rows should be shown

For example:

G H
1 0
2 0
1 1
2 0
0 0
0 0

So if you filtered the above i want to be able to see all of the rows except the last two as they both have zero's.

thanks for your help!!

[md1972]

Quickest way could be to use custom filter on each column (custom, is greater than 0)

[dandavis1]

Unfortunatly i have tried that and it only leaves me with rows which have a number greater than zero in both columns

so going back to my original example below it only shows me one row which is the row with both 1's in column G and H, where i want to be able to see every row except the last two. It doesnt matter that there is a zero in G and a Number in column H or visa versa, i want to see it. Its only when both columns are showing zero i dont want to see them.

G H
1 0
2 0
1 1
2 0
0 0
0 0

Thanks again.

[JBeaucaire]

To use an AutoFilter to accomplish this, you would need to add another column to your data to give you a key. In that column would be a formula that tested both G and H on that row for values greater than 0. Something like:

=OR(G2>0,H2>0)

....copied down that column...then you filter that new column based on the values that are TRUE.

[md1972]

Unfortunatly i have tried that and it only leaves me with rows which have a number greater than zero in both columns

so going back to my original example below it only shows me one row which is the row with both 1's in column G and H, where i want to be able to see every row except the last two. It doesnt matter that there is a zero in G and a Number in column H or visa versa, i want to see it. Its only when both columns are showing zero i dont want to see them.

G H
1 0
2 0
1 1
2 0
0 0
0 0

Thanks again.

Sorry wasn't thinking straight