Trying to retain data with multiple filters

[flindip]

Hi, I'm trying to filter out two seperate columns on spreadsheet with values of zeros. Basically, I want to filter the columns that BOTH contain values of zero(not just one). I was think of using a nested if statement(I am unsure if that is the most effective method). I'm pretty green at Excel, so any help would be welcome.

If you need more information, I will be glad to provide it(however, there are some confidentiality issues with the actual data).

Thank you.

 

[Fluff]

Why not just filter both columns to show only zero

 

[flindip]

Well, the reason is that both columns need to be the value of zero for me to filter it. One column can't be zero and the other column having a value(Excel doesn't seem to be able to distinquish).

The columns look something like this:

Product/ Client/ Cost/ Percentage Cost/ Unit/ Bulk

Unit AND bulk values need to BOTH be zero in order to filter the data(thats the requirement). If I have 5 in Unit and zero in Bulk(or vice-versa): Excel will just filter the entire row.

I apologize if I am not articulating this properly.

 

[flindip]

I should add that I'm already adding a filter to the client column.

 

[Fluff]

Are you trying to hide rows where both are 0 or show them?

 

[flindip]

I would assume hide. I just want to filter if BOTH unit/bulk are zero. I guess I could also just put in a placeholding value as well. But, filtering zero in the columns(individually)ends up eliminating columns with data in unit(or bulk).

 

[Joe4]

So you only want to hide columns where they BOTH are zero.
One way would be to use a helper column, that checks to see if they are both zero, something like this:
=AND(A2=0,B2=0)
and then filter on that column.

 

[Fluff]

Have a look at this & see if it helps
https://www.mrexcel.com/forum/excel...ere-multiple-columns-blank-2.html#post3853123

 

[flindip]

So you only want to hide columns where they BOTH are zero.
One way would be to use a helper column, that checks to see if they are both zero, something like this:
=AND(A2=0,B2=0)
and then filter on that column.

Thank you both Fluff and Joe4. This seems to be what I am looking for. I will try to implement this later and see if it works. Thanks again, both of you...