View Single Post
 
Old 02-17-2015, 02:58 AM
Richard121 Richard121 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2015
Posts: 10
Richard121 is on a distinguished road
Default Drop down lisr with multiple choices

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
Reply With Quote