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
Watch video Google Sheets - Create a Dynamic Search Bar with Query and Filter online without registration, duration hours minute second in high quality. This video was added by user Eamonn Cottrell 26 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 70,856 once and liked it 763 people.