How to insert multiple filters to filter one persons name from different column

[pupadhya]

Dear All,

We are into aviation training; and we have several instructors conducting classes different batches, so I have created Excel file along with Batch details and I have assigned Instructors as per the classes according to the date. Now I have excel sheet where 4 batches are running simultaneously and I have assigned same instructor into different batch as per his availability.

My requirement:

I wanted to filter Instructor name across different batches, so that I get to know his utilization into different batches and when is he busy doing what classes.

Example: I have file table like this:
CLASS/TIME SFI GSI
ELT-GS/1000-1800 DEV GHOSH

I have the above table for multiple batches, so now when I filter, I would like which batches where SFI(Instructor) DEV GHOSH involved across all the 4 batches in the table.

I have attached my file for your reference, please help me how can i inert multiple filters into different batches so that i get to know the utilization of one instructor.

I have also posted my problem in other forum, please find the link below:
How to insert Multiple Filters or Write VBA or Excel way to filter (http://www.excelforum.com/excel-programming-vba-macros/955834-how-to-insert-multiple-filters-or-write-vba-or-excel-way-to-filter.html?p=3410648#post3410648)
Please help.
Regards,
Pramod

[Excel Fox]

Is this what you are looking for?

[pupadhya]

Hello Administrator, Thank you so much for the help, It worked but my requirement is partially solved, however my requirement was to filter unique person name ( now it is happening ) and It should only show his records and rest should be gone when I filter it,

Presently it is filtering that persons name, however it is showing record of others too, however I want only one persons record when I filter it..

Basically when i filter i want only one persons name and against him i want his CLASS/TIME column and Date and week day column day to appear.

Thank you so much for your patience and for your help.

Regards,
Pramod