Multiple values on a cell from a list

[UnoSD]

Hi everyone,

I have a budget spreadsheet, with expenses and descriptions.

Each description contains a list of stuff bought, often the same stuff.

Is there a chance to have a dropdown list with a multiple selection? Like a dropdown with checkboxes taking the list from somewhere.

So, everytime I buy A, B, C and D. I just have to check them on the list without typing them. This will be useful to make some calculation on the quantity (i.e. How many B have I bought till now?) will I be able to do that as well? How?

Thanks.

[UnoSD]

@w_whalley This is just for one item per cell. I need more item each, comma separated or whatever.

[StefanM]

Hi UnoSD, have you found a solution? I also need to have a dropdown list with multiple selection in a spreadsheet.

[w_whalley]

If your purchased items are in a block of cells with one item per cell, you can use them as the source of the drop down list.

Select your list of purchased items, and give that range a name, e.g. “items”. Select a cell for your drop-down list and on the menu pick Data/Validity. In the dialog Criteria tab Allow Cell Range. Check Allow blank cells, Show selection list and Sort entries ascending. In the Source box put your range name “items”. When you click OK, a drop-down arrow will appear next to the selected cell. The items on the drop-down list will come from your “items” list.

You can count occurrences of the selected item using the COUNTIF function. In another cell enter =COUNTIF(items,A1) where cell A1 refers to your drop-down list cell.

[UnoSD]

This is just for one item per cell. I need more item each, comma separated or whatever.