Hide blank cells in either of 2 columns

[Brian]

If I want to hide the rows of a worksheet which are blank in a particular
column, I can do that easily with Data | Filter. But now I want to hide any
row where the cells in columns R and S are both blank.

How can I do that?

 

[Lori]

If I want to hide the rows of a worksheet which are blank in a particular
column, I can do that easily with Data | Filter. But now I want to hide any
row where the cells in columns R and S are both blank.

How can I do that?

Try using a helper column, e.g. filling down:

=COUNTA(R2,S2)

Then filter for non-zeros in this column.

 

[Brian]

Thanks Lori,

Columns R and S contain formulas like this all the way down:

=IF(SUM(M16:N16)=0,P16,"")

so COUNTA doesn't work. I am trying to work out something else, based on a
helper column, but I would appreciate any suggestions.

Brian

 

[Lori]

Thanks Lori,

Columns R and S contain formulas like this all the way down:

=IF(SUM(M16:N16)=0,P16,"")

so COUNTA doesn't work. I am trying to work out something else, based on a
helper column, but I would appreciate any suggestions.

Brian







- Show quoted text -

How about filtering TRUE in: =COUNTBLANK(R16,S16)<2