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.
Please help.
Regards,
Pramod
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.
Please help.
Regards,
Pramod