Google Sheets and Excel - A Better Dynamic Search Bar

🚀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