Hide blank cells in either of 2 columns
 

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?

Hide blank cells in either of 2 columns
 

On 12 Mar, 15:07, "Brian" wrote:
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.

Hide blank cells in either of 2 columns
 

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" wrote in message
oups.com...
On 12 Mar, 15:07, "Brian" wrote:
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.

Hide blank cells in either of 2 columns
 

On 12 Mar, 15:47, "Brian" wrote:
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" wrote in message

oups.com...



On 12 Mar, 15:07, "Brian" wrote:
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.- Hide quoted text -

- Show quoted text -

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