How to make Advanced Search Box in google Sheets

In this short video, I will show you how to make your own custom search box to get filtered results.
You can either search globally or you can also provide a column where the searches should be performed.
Spreadsheet Link: docs.google.co...
#googlesheets #filters #search

[@abdullahquhtani4247]

I have a suggestion and I hope you consider it 😏.
It’ll be great if you could add one parameter that customize search by adding one drop-down field contains (Equal, Start with, Ends with, Less than and grater than) and filter will be applied accordingly 👍🏼

[@tech-lever]

Not in this version. But I will do that in Web app version, exactly what you mentioned.
Suggestion much appreciated 👍

[@kennethgarcia1178]

❤❤❤

[@sajinj2457]

I liked your video. Please advise what if I need to show only particular columns only in filter 2 sheet instead of showing entire sheet columns. Kindly explain the steps to follow

[@zohairdilawar116]

Nice

[@BraveHeart-ht8zf]

good scripts, but if I input age=28 (formt number) not work (work only text)..add modify script ?

[@tech-lever]

Modified. Thanks for pointing that out. Much appreciated.

[@zohairdilawar116]

Sir please reply my email