Filter Multiple Columns

**georgedaly** · 07-19-2013, 07:11 AM

Hi all,

I am currently using an excel spreadsheet that outlines when an apprentice/employer is due a survey.

I have 8 main columns that I need to apply a filter to.

G - Date 6 Week Employer Evaluation Form Completed
H - Date Employer Emailed
I - Date 6 Week Learner Evaluation Form Completed
J - Date Learner Emailed
K - Date 6 Month Employer Evaluation Form Completed
L - Date Employer Emailed
M - Date 6 Month Learner Evaluation Form Completed
N - Date Learner Emailed

I would like to be able to filter multiple columns to only include rows that contain a date, due to the fact that there are many learners/employers who have not yet been due to receive a survey. I do not want to have to print a spreadsheet with vast amounts of rows with blank data.

Apologies if this query is difficult to understand, it's hard putting thoughts to paper.

Any help would be greatly appreciated.

Thanks.

**martindwilson** · 07-19-2013, 07:53 AM

assuming those cells are always dates or blanks or text then try this filter last column on true

**georgedaly** · 07-19-2013, 08:19 AM

Hi Martin,

I appreciate the advice and response, however I would by no means consider my self adept in excel. Therefore,I have attached a censored version of my spreadsheet as I am unsure how to apply your technique to my spreadsheet.