Advanced Filter Assistance?

[BBDaryl]

Hi Folks,

I have a spreadsheet used for holiday entitlement where by the layout is very much like a Gantt chart, each month is separated into columns and which correlate to the days of the week, each row relates to an employee.
At the moment we have an auto-filter applied, allowing the user to filter down any specific day that people were off, or any particular employee.

What I would like to be able to do is leave this layout in tact, (a drop down auto-filter like option, to allow filtering by each employee) while also having the ability to filter down all results in a certain 7 columns, (1 week) of which are not NULL

While this can be done on a day by day basis using auto-filter, I cannot seem to find a simple way to keep the auto-filter like drop-downs while having an "OR" statement for ANY day of the week, any ideas how this could be done?

Example Image

Basically I need to filter the results in any 1 week, down to those who have had time off within that month only in the easiest way possible.

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. Pictures are little use to us.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

[BBDaryl]

I'll see what I can do, will have to whip up an example worksheet as I have to leave in a moment (end of the work day) I'll pop by tomorrow and update the post, sorry.