Published On Feb 13, 2024
🚀Join my free tech newsletter: https://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: https://docs.google.com/spreadsheets/...
=============================
Items & Courses (affiliate links)
My Amazon page with item suggestions I can't live without: https://amzn.to/3uqSO7Q
â–º Best Home Coffee Maker, hands down: https://amzn.to/3rjdjSr
â–º Best Mechanical Keyboard for data analysts: https://amzn.to/3NUDiaq
â–º Best Wrist Pain Remedy: https://amzn.to/44Oq7il
â–º Best Standing Desk: https://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: https://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