

August 25, 2017

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

This was covered in a video tutorial just last week: select multiple items from a drop down list.


August 25, 2017

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

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

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


July 16, 2010

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)
