Google Sheets - Intelligent Search to Filter Data

Learn how to build an intelligent search function to filter data using a scoring system in Google Sheets.

#search #filter #data

[shaikan]

You channel rocks brother! Thank you for all the effort you out into this. You're literally helping people improve their careers if they take the time to watch and learn.

[nattybbogle]

Your channel has elevated my work life immensely please keep doing what you’re doing

[arnellcarmichael]

Man, this is super Dope! Especially when talking to clients and searching for information on the fly. I am going to utilize this in my google sheets CRM, and this Search function will help tremendously! Thanks, Brother!

[ViniBevilacqua]

This is ultra high quality content!
Congrats dude!

Just found your channel and i'm now hooked to it!
Thank you so much!

[tomasrampas]

This tutorial still rocks. With this, I was able to make search in a way, that it searches text OR a tag that can be selected from a dropbox. And it works!!! I am so happy :)

[delphinelouise]

Wow! I am so impressed with your work! Wonderful!

[ahamedjameel]

You guys are the real heroes for me. Clear magicians.
Thanks a lot guys.

[sharitambasco]

Awesome as always. I like it when you take a second to explain all your little tricks, like you did with cut vs paste to update the reference. Thanks for posting, I check everyday :)

[natalieforood]

This is so helpful and you explain things so clearly and methodically! Thank you!

[sanpatel]

God bless you dear for helping & sharing knowledge

[tridsonline]

👍🏻 Excellent .. i love the clever solutions, but i greatly appreciate your style of building up to them and showing how you get there.
Thank you!

[rontrejos]

Awesome the simple way you make it, I actually did it for a work task I had for months sitting there, keep it up!!!

[DavidGomez-leif]

feww, that took a lot of digging, I was searching how to make this exact kind of search box, I did find others that linked other sheets, and some that just use the simplest method, "search-box" however this is exactly what I was looking for thank you very much, I will keep watching your videos to learn more,

[homerovelasco]

Thanks for the video! It is super helpful. I have one question. Can I get search results for the whole spreadsheet if it has more than 1 tab. How can I set up the search results to include results from all tabs on the sheet?

[burkygayaban]

Hi! How do you search in multiple columns example on your video you are searching in column B. How about adding additional column like searching in column B, C, and D?

[snake]

your videos are gold. Keep it up guys!

[gonzalomolina]

Fantastic and useful presentation! Thank you. Question (maybe already answered): is it possible to make the filter "live" without pressing ENTER each time to filter it again?

[waynetrieu]

Thank for your work! But is it possible to edit one cell directly in search sheet and it will automatically update the data in the main sheet?

[mutiapratiwi]

Hi! thanks for the video, I wonder is it possible to store the data and match score formulas in google drive or clouds and create the search bar in google sheets? I have lot of data and google sheet can't help, I try to use excel but some formula didn't work...

[steven]

Is it possible to make it an arrayformula to match for an entire column (so that I don't have to pre-drag the formula)