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