Google Sheets and Excel - A Better Dynamic Search Bar
This is the best way to create a fully functional, dynamic search bar in your spreadsheet. I used Google Sheets so I could make it more shareable with the most number of people, but everything here will work in Excel as well.
⭐ Get the FREE sheet here - https://www.gotsheet.xyz/c/a-better-d...
Here's the formula from the video: =if(ISBLANK(C3),"",SORT(filter(transactions,SEARCH(C3,INDIRECT(C2))),3,FALSE))
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 - Setup
00:00:45 - Breakdown
00:01:24 - The Formula
00:01:34 - How it Works
00:01:50 - SEARCH
00:02:51 - FILTER
00:04:40 - SORT
00:05:21 - IF
=============================
#googlesheets #spreadsheets #dataanalytics #excel #productivity
Watch video Google Sheets and Excel - A Better Dynamic Search Bar online without registration, duration hours minute second in high quality. This video was added by user Eamonn Cottrell 13 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 19,488 once and liked it 673 people.