Advanced filter for blank rows

[Orange101]

I have a simple list of data with one column headed NAME and several columns each headed with a month of the year (Jan, Feb etc). What I am looking to do is filter the list so that those individuals in the name column who have no data for any of the months are hidden - leaving those rows that contain either some, or complete data. In other words I want to hide blank rows in my data area.
Autofilter doesn't work as "nonblank" only filters by a single column. I've tried an advanced filter using a criteria range with a blank first line and computed criteria =isblank(a2)=FALSE etc but whilst that gets rid of the completely empty rows it also removes the rows that are partially complete!!
Any suggestions?

 

[yeheya]

One way to do this:

Add an additional column which will contain a condition formula (eg: if(b1="",if(c1="",if(d1="","Hide")))

Filter on this column where value is HIDE

Regards,
Yeheya

 

[GorD]

Just put a total at the end of the data (=sum) and the filter on >0

 

[Orange101]

Thanks for that Yeheya - did the trick - I've adjusted the formula slightly by putting an AND function in as part of the logical test (not quite so many brackets that way!!) and it's working like a charm.

One way to do this:

Add an additional column which will contain a condition formula (eg: if(b1="",if(c1="",if(d1="","Hide")))

Filter on this column where value is HIDE

Regards,
Yeheya