Filter non-blanks from selected columns

**rajivbravo** · 08-03-2012, 08:51 PM

I have dates starting from today until end of the year as header row, and activities specified in the header column. An activity can be done on a specific day. Not all activities are done daily so I have lots of blank cells to deal with. Even the activities are around 300 in number adding to difficulty while reviewing the week.

To review activities in a week/fortnight/month I have to select individual column filter all non-blanks value. Is there a smart of selecting multiple columns and filtering non-blanks.

I have googled it around and the best bet seems to be copying it to somewhere else...definitely not the solution that can help me. I am keen for just a filter that can help me select non-blanks for a week/fortnight (or selected columns), as any changes to a activity should be reflected in the cell itself.
Any help or guidance will be highly appreciated.

BRgds

**dilipandey** · 08-04-2012, 12:14 AM

HI Rajiv,

Welcome to the forum.

Since filtering one column affects the filterable choices of another column(s), I am not sure if you can select all non blanks for all columns

Try it by applying autofilter and start choosing non-blanks from any column onwards, you'll get to see my point what I have said above. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**rajivbravo** · 08-06-2012, 06:02 AM

Thanks Dili,

Yes that is the constraint I am working against. Not sure if macro can help this. I have tried selecting multiple columns and filtering ..it doesn't help either.

Brgds