Drop down lisr with multiple choices

[Richard121]

Using Excel 2013 is it possible to create a drop down list with multiple selections.



For example, and without going into the definitions, I could have the following categories:
Owner/Occupier
Tenant
Landlord
Grazier
Licencee
Agent

I want to create a dropdown list that allows me to enter one or more of these categories. Someone might only be a Landlord - that is simple. But someone might not only be a Landlord, but on another piece of land might be the Owner/Occupier, and is thus both. I do not want to have to create a list with the Combinations listed!

I also want to be able to filter on the list, for example in this case, either under Landlord, or under Owner/Occupier, or under Landlords who are Owner/Occupiers.

Can this be done? If so, how so?

Thanks

Richard