Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2015, 02:58 AM
Richard121 Richard121 is offline Drop down lisr with multiple choices Windows 7 64bit Drop down lisr with multiple choices Office 2013
Novice
Drop down lisr with multiple choices
 
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
  #2  
Old 02-17-2015, 08:30 AM
gebobs gebobs is offline Drop down lisr with multiple choices Windows 7 64bit Drop down lisr with multiple choices Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

This can't be done with the drop downs created simply with data validation. It can be done with List Box form control. However, you would have to make one for each record so it's not really esthetic.

On the other hand, you might be able to work something using data relationships. I don't think this is available in my Excel but I see you have 2013.

http://www.pcworld.com/article/24622...xcel-2013.html

It also may be done using a pivot table.

http://superuser.com/questions/47346...lls-in-a-large
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down lisr with multiple choices How to synchronize the choices on several identical drop down menus liyproswell Word 2 12-11-2014 06:08 AM
Drop down lisr with multiple choices Multiple Choice Drop Down List teza2k06 Word 1 04-29-2014 04:54 PM
Populate a table based on choices from drop down menu Xaand Word VBA 0 02-25-2014 11:08 AM
Multiple Drop Down Lists in word ali212006 Word 3 03-13-2013 12:16 PM
Multiple drop caps Ziggy-R Publisher 0 10-26-2010 06:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft