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.
|