Log In
Register
Home
August 25, 2017
Offline
Hi,
Can you help me with this issue. Is it possible to have a drop down list whereas I can choose multiple items from the list to appear in a particular cell?
THE GOAL IS TO HAVE A DROP DOWN BOX FOR EACH COLUMN. WILL NEED TO HAVE THE ABILITY IN SOME INSTANCES TO CHOOSE MORE THAN ONE ITEM. IS IT POSSIBLE TO HAVE MULTIPLE ITEMS? FOR EXAMPLE, IN COLUMN M, THE SELECTIONS MAY BE 1, 7, 8 AND 12. IN COLUMN P, THE SELECTIONS MAY BE 3, 6, 9, 15. THIS WILL APPLY TO ALL THE COLUMNS THAT HAVE THE GREEN BOX "CHECK ALL THAT APPLY". I WOULD LIKE TO SEE THE INFORMATION LISTED IN ONE CELL, SEPARATED BY A COMMA.
IS THE DROP DOWN LIST THE CORRECT PLATFORM TO ACCOMPLISH THIS TASK?
THANKS
July 16, 2010
Offline
This was covered in a video tutorial just last week: select multiple items from a drop down list.
August 25, 2017
Offline
Thank you so very much. This is exactly what I needed! The second question, is there a way to tally the responses. I plan to create a separate spreadsheet, and tried the "countif" formula but it doesn't work. Is there a simple formula to count the number of responses? For example, how many "1" are there
August 25, 2017
Offline
Mynda
Regarding the select multiple items from a drop down list, is there a way to tally (count the number of times Alpha was chosen, and number of times Charlie was chosen and etc.)? To have the ability to select multiple items from a drop down list is really awesome!
Thanks
July 16, 2010
Offline
There's no easy formula for this and that's because Excel wasn't designed to stuff multiple items from a data validation list into one cell 🙂
You can use this array formula: =SUM(--ISNUMBER(SEARCH("Charlie",C4:C8)))
Where your data is in cells C4:C8 and you want to find how many times 'Charlie' is listed.
Note: If you're using Excel 2019 or earlier you need to enter the formula with CTRL+SHIFT+ENTER
Myna
August 25, 2017
Offline
Mynda,
I will give it a try. Thank you so very much.
August 25, 2017
Offline
Mynda,
It worked perfect. I have two questions.
(1) how do I limit certain columns within the spread sheet to only one choice?
(2) Are you familiar with Microsoft forms, is there a way to link the form to the spreadsheet or vice versa?
Thanks
July 16, 2010
Offline
In the cells that you only want them to be able to select one item, simply insert a regular data validation list as this is their default behaviour.
Yes, I'm familiar with Microsoft Forms. I've got a tutorial on Microsoft Forms here. You can't retrospectively link a form to an existing spreadsheet. You have to create the form, which creates the spreadsheet and then use that spreadsheet.
Mynda
1 Guest(s)
