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.