Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide rows of cells that are blank | Excel Discussion (Misc queries) | |||
Hide row if all cells in another range are blank | Excel Discussion (Misc queries) | |||
Macro to hide the row if both columns E & F are blank in that row. | Excel Worksheet Functions | |||
Hide columns & rows that contain "0" or blank in a range of cells | Excel Worksheet Functions | |||
Pivot Table - hide blank cells | Excel Discussion (Misc queries) |