2024 Update: Multiple Selection Data Validation in Google Sheets

[@KawaiiAnneCorner]

Thank youuu!! I am looking for this

[@interact-yugal]

There's still an issue, when it comes to querying or filtering data - while filtering it is considering all the individual data points as a single data point which defeats the whole point of multiple selection

[@EamonnCottrell]

I've got it figured out for filtering, but you may be right with the querying...i'm not sure how to fix that one. It's because it's storing the cells in a comma-separated array. But to get it working with filter, you can do this: =FILTER(Table1[Fav Color],SEARCH(L1,Table1[Fav Color]))
where L1 holds the color you're searching for. It'll then filter for every row that contains that color

[@giovannibortolotti6686]

Thanks Eamonn!!!

[@EamonnCottrell]

You’re welcome!

[@ronaldjohnson_ita]

Great video!

[@EamonnCottrell]

Thanks!