Multiple Answers From Drop Down List
A client of mine wants to include a drop-down list in Excel. The twist is
that she'd also like people to be able to choose more than one item from the list in response to a question. For example, if people are asked why they like bread, they can choose one or more answers from a list with tasty, chewy, soft, nutritious. Can this be done in Excel? If so, how? Thanks! |
Multiple Answers From Drop Down List
Two ideas: You can either use multiple columns, and have user pick different
answers in each column, or you could use a list box (from Forms toolbar). Under format contol, select the option to allow multiple selections (either "multi" or "extend".) The bigger question is how is the data from this dropdown to be user? If it is to simply be displayed, you have numerous choices. If it's supposed to be fed into some type of data analysis, then you need to keep 1 data point in each cell. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "MaryAM" wrote: A client of mine wants to include a drop-down list in Excel. The twist is that she'd also like people to be able to choose more than one item from the list in response to a question. For example, if people are asked why they like bread, they can choose one or more answers from a list with tasty, chewy, soft, nutritious. Can this be done in Excel? If so, how? Thanks! |
Multiple Answers From Drop Down List
If you use Luke's method the date can be extracted with an array formula.
if a2 and a3 contain: tasty, chewy, soft, nutritious chewy, soft, nutritious and G3 contains Soft then =SUM(IF(ISNUMBER(SEARCH(G3,A2:A3,1)),1,0)) returns 2. Array formulas must be entered as Ctrl + Shift + Enter. You can tell that is correct as Excel enclosed the formula with curley braces {}. HTH Peter A "Luke M" wrote: Two ideas: You can either use multiple columns, and have user pick different answers in each column, or you could use a list box (from Forms toolbar). Under format contol, select the option to allow multiple selections (either "multi" or "extend".) The bigger question is how is the data from this dropdown to be user? If it is to simply be displayed, you have numerous choices. If it's supposed to be fed into some type of data analysis, then you need to keep 1 data point in each cell. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "MaryAM" wrote: A client of mine wants to include a drop-down list in Excel. The twist is that she'd also like people to be able to choose more than one item from the list in response to a question. For example, if people are asked why they like bread, they can choose one or more answers from a list with tasty, chewy, soft, nutritious. Can this be done in Excel? If so, how? Thanks! |
Multiple Answers From Drop Down List
Check out http://blog.contextures.com/archives...lidation-list/
--JP On Sep 30, 9:51*am, MaryAM wrote: A client of mine wants to include a drop-down list in Excel. The twist is that she'd also like people to be able to choose more than one item from the list in response to a question. For example, if people are asked why they like bread, they can choose one or more answers from a list with tasty, chewy, soft, nutritious. Can this be done in Excel? If so, how? Thanks! |
All times are GMT +1. The time now is 04:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com