Filter people by skills?

[Jamieneedshelp]

Hi.

I have a spreadsheet like the below.

Each of the staff in column A teach subjects, some the same, some different. When plotting what they're each teachig each day below the date columns id like to be able to filter their names by what subjects they teach.

So if on the 2nd April I'm looking for a french teacher I can see my options. If that all makes sense?

 

[awoohaw]

Is this an excel workbook?

where are the subjects in your workbook?

Mr. Excel has a tool called xl2bb add in, please use that to post a mini worksheet of your data.

Thank in advance.

 

[Jamieneedshelp]

Thanks for your reply. I would create a tab or the data in any way that you could advise enables me to filter the column above.

For examples sake it might show Jane teaches french and German. Fred - German and Italian. Dan - Italian and Spanish

 

[awoohaw]

Are you asking for a drop down based upon the name to the left?

Please post some sample data and a sample output. If you have data validation, please describe or post an image of the DV editor.

 

[Jamieneedshelp]

No a filter that has the subjects I can select from above the name column. Once I've selected the subjects it shows me only the people's names in that column that can teach those subjects

 

[Jamieneedshelp]

Sorry I'm a real novice and the trainer list I have numbers in the 20s and they all teach numerous subjects. I want to be a be able to say I need a french teacher for the 4th April. So somehow have attached to that column their skills in some hidden manor

 

[awoohaw]

Are you open to other ways to get your excel solution?

 

[Jamieneedshelp]

Sorry I'm a real novice and the trainer list I have numbers in the 20s and they all teach numerous subjects. I want to be a be able to say I need a french teacher for the 4th April. So somehow have attached to that column their skills in some hidden manor

Are you open to other ways to get your excel solution?

Absolutely

 

[awoohaw]

Sorry I'm a real novice and the trainer list I have numbers in the 20s and they all teach numerous subjects. I want to be a be able to say I need a french teacher for the 4th April. So somehow have attached to that column their skills in some hidden manor

Absolutely

Okay, try this: (I"ll post a shared link to the file below as well)

Here is a link: (MS One Drive)

JamieNeedsHelp.xlsm

1drv.ms

 

[Jamieneedshelp]

@awoohaw any chance you could be a life saver and translate this to excel 2016