Google Sheets - Create a Dynamic Search Bar with Query and Filter

This is how to create a dynamic search bar using a couple different methods in Google Sheets.

Get the FREE sheet here - https://www.gotsheet.xyz/c/dynamic-se...

📌I've made an updated video you may want to check out too with what I think is a cleaner way to make this search bar:    • Google Sheets and Excel - A Better Dy...  

I'll show you ✌️two ways to make a dynamic search bar in a Google Sheet to display data based on what you type.

🤔And I'll explain why one is better than the other.

🔥Let's go!+

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

🎓Software Recommendations:

► Starting a Newsletter? Check out Beehiiv with a free trial and 20% off your first 3 months: https://www.beehiiv.com/?via=eamonn
► ConvertKit - creator marketing & newsletter platform - https://partners.convertkit.com/358pj...
► HubSpot free CRM software for sales, marketing, customer service, operations teams. https://hubspot.sjv.io/c/4186908/1001...
► Notion - productivity & note-taking app - https://affiliate.notion.so/p7771a8zwlsu
► Carrd - one page landing sites - https://try.carrd.co/s4x1c97b
► Coefficient - import data and sync with your business systems in Google Sheets - https://coefficient.io/?via=984f9f

_______________________________________________
🎓Data Course Suggestions: (coursera)

► Advanced Data Analytics Certificate by Google: https://imp.i384100.net/21dWGa
► Microsoft Power BI Data Analyst Certificate - https://imp.i384100.net/4PgjK3
►Microsoft Business Analyst Certificat - https://imp.i384100.net/anamAq
► Cybersecurity by Google: https://imp.i384100.net/VmN6oM
► Google Cloud Data Analytics Certificate - https://imp.i384100.net/B0ZJb0

_______________________________________________
🎓AI Course Suggestions: (coursera)

► IBM AI Developer Certificate - https://imp.i384100.net/B0ZR9L
► Overview IBM AI Engineer Certificate - https://imp.i384100.net/KjnyA9
► Google AI Essentials - https://www.coursera.org/learn/google...

_______________________________________________

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

📲 Find me
on LinkedIn:   / eamonncottrell  
on Twitter:   / eamonncottrell  
_______________________________________________

⌚Chapter Time Markers:

00:00:00 - Intro
00:00:30 - Subscribe!
00:00:41 - The Data
00:01:29 - The Search Bar
00:01:42 - Query Solution
00:02:47 - Case Sensitivity
00:04:07 - Filter Solution
00:04:58 - Query with Multiple Conditions
00:05:40 - Filter with Multiple Conditions
00:06:26 - Which is Better? Query or Filter?

=============================
#googlesheets #spreadsheets #dataanalytics