🚀Join my free tech newsletter: got-sheet.beehiiv.com/
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.
Here's the formula from the video: =if(ISBLANK(C3),"",SORT(filter(transactions,SEARCH(C3,INDIRECT(C2))),3,FALSE))
Here's the sheet used in the video: docs.google.com/spreadsheets/...
=============================
Items & Courses (affiliate links)
My Amazon page with item suggestions I can't live without: amzn.to/3uqSO7Q
► Best Home Coffee Maker, hands down: amzn.to/3rjdjSr
► Best Mechanical Keyboard for data analysts: amzn.to/3NUDiaq
► Best Wrist Pain Remedy: amzn.to/44Oq7il
► Best Standing Desk: amzn.to/3PV4oRo
Some data course suggestions:
► Advanced Data Analytics Certificate by Google: imp.i384100.net/21dWGa
► Cybersecurity by Google: imp.i384100.net/VmN6oM
►Need a powerful automation tool for Google Sheets? Try Coefficient to automatically import data and sync with your business systems: coefficient.io/?via=984f9f
=============================
⌚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