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/abetterd...
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 & notetaking 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