| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
