Google Sheets - Intelligent Search to Filter Data

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?

Thank you for all the techniques...

I can search engine find all excel sheet ?

this is a whole class :) Thank you!

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

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

Bro! Do you know how to filter it and return the result from the vertical to horizontal position?

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 :)

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?

thank you dude, you solve my problem auto subscribe for you

Can you share a version of this sheet?

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?

Is there a way to get access to copy these sheets to work on so I can follow along rather than spending n amount of time adding data to a new sheet? Thank you. These videos are awesome by the way.

WTF BRo °_____°

Thank You for making this Nice Searchbox I love it Keep it Up. I subscribed.

THANK

God bless you dear for helping & sharing knowledge

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!

I only have one issue whenever I input additional data in the range the search box will not populate this result., any suggestions?

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...

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,

Great inspiration! What if I wants to be able to search in both description and item number, is that possible?

There is NOTHING "Intelligent" about this Search, this is not even a Search, it's like mental Masturbation.

Thanks for this incredible toturial; it works good, but it doesn't seem to work with numbers only with text, can you help me with that???

Your videos always inspired me 💕

This is ultra high quality content!
Congrats dude!

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

You rock dude!

is there some smart way to search multiple columns and in multiple sheets? when I try to make an array of filters I get an array_literal error and when I search on more than one column I end up with matches of 200%+

How can I get this training worksheet?

hello, great video, just one question , it is possible to do the search in all sheets with the same filter ?

Hi very nice video.....Where are you from...I am from South India

This is great. I love it! I got confused as to why you added the division inside the arrayformula.. would it work outside also? Thanks!

Thanks. That has helped me a lot. My application requires much the same.

Wow this is incredible.

I would love to a follow up video showcasing an Excel LAMBDA/ LET solution

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

Awesome.

Great vídeo!!

For some reason COUNTA is giving me a wrong answer. On a string of 6 words it returns an answer of 2. So I can't get this to work.

Now its just missing sort by closest match but that's easy enough. Awesome content as always!

Your videos are fantastic. They're the first thing I look at when I start something including the spreadsheet I reference below.

Query question: is it possible to use concatenate in the data source? Something like: =QUERY(concatenate(B3,"!A1:E "),"Select * Where B is not null"). I'm using a drop down to change the data source from a bunch of other sheets in the workbook. It's working fine, but it's not an elegant solution.

Here's what's working :

=QUERY({Mobility!A1:E; Control_over_Environment!A1:E; Seating_and_Positioning!A1:E; Hearing_and_Listening!A1:E; Study_and_Organizational_Skills!A1:E; Math!A1:E; Environmental_Control_and_Computer_Access!A1:E; Oral_Communication!A1:E; Reading!A1:E; Spelling!A1:E; Written!A1:E; ADL!A1:E; Vision!A1:E; Recreation_and_Leisure!A1:E; Pre_Post_Vocational!A1:E}, "Select Col2,Col3,Col4,Col5 where Col1 ='"&B3&"' ")

Quick question: Can I create such a search filter with people's names? We deal with recurring customers.

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

Thanks so much for your inspiration. That helps me a lot in my daily job.
Keep it up!!!

how to get this dataset

Please put more videos about data studio and related new data handling softwares and applications 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻

Awesome work bro I learnt a lot from you .

could we apply those formula on excel without getting an errors

that was such great tutorial, you simply build a google search machine inside google sheets , kkk kkk

Congratulations.
You video great thanks from turkey 👏👏👏👏