View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lori Lori is offline
external usenet poster
 
Posts: 340
Default 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.