2024 Update: Multiple Selection Data Validation in Google Sheets

We've got them! Multiple selection data validation selections are now native in Google Sheets!

This comes directly on the heels of tables finally rolling out over the last few months.

Good times!

This video goes over the couple things that most people asked me about in that video.
=============================

We receive commission on purchases made through some links on this page

🖥️ Office items I can't live without:

🎓Course Suggestions:

=============================

📲 Find me

=============================

⌚Chapter Time Markers:
00:00:00 - setup
00:00:14 - old way
00:00:51 - 2024 updated way
00:01:08 - table
00:01:20 - data validation setup
00:02:26 - demo counting values
00:03:17 - split
00:03:51 - counta for unique values
00:04:51 - arrayformula
00:05:49 - countif plus arrayformula
00:07:01 - adding table rows
00:07:25 - multiple criteria dynamic checkbox preview

[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