Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?



  #2   Report Post  
Posted to microsoft.public.excel.misc
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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 340
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide rows of cells that are blank dford Excel Discussion (Misc queries) 9 February 5th 07 12:35 AM
Hide row if all cells in another range are blank dford Excel Discussion (Misc queries) 2 February 3rd 07 07:21 PM
Macro to hide the row if both columns E & F are blank in that row. PCakes Excel Worksheet Functions 2 January 4th 07 11:07 PM
Hide columns & rows that contain "0" or blank in a range of cells lw new guest Excel Worksheet Functions 0 August 18th 05 05:27 PM
Pivot Table - hide blank cells Kirk P. Excel Discussion (Misc queries) 1 August 18th 05 03:42 AM


All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"