2024 Update: Multiple Selection Data Validation in Google Sheets

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

Get Good at Spreadsheets Now: https://gotsheet.xyz/subscribe

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

Good times!

I made another popular video on this topic a couple years ago when we had to use apps script to make it happen:    • Multiple Selection Data Validation in...  

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

🗞️ Starting a Newsletter? Check out Beehiiv with a free trial and 20% off your first 3 months: https://www.beehiiv.com/?via=eamonn

🖥️ Office items I can't live without:
https://amzn.to/3uqSO7Q (amazon)

🎓Course Suggestions:
► Advanced Data Analytics Certificate by Google: https://imp.i384100.net/21dWGa (coursera)
► Cybersecurity by Google: https://imp.i384100.net/VmN6oM (coursera)

► HubSpot free CRM software for sales, marketing, customer service, operations teams. https://hubspot.sjv.io/c/4186908/1001...

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

📲 Find me
on LinkedIn:   / eamonncottrell  
on Twitter:   / eamonncottrell  
on website: https://www.eamonncottrell.com/

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

⌚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