Search Bar in Google Sheets

Рет қаралды 9,902

10 ай бұрын

Ever wanted to have search bar in your google spreadsheet and make it easier to view information? Then this video is for you.
You can find my new favorite way to search in this video: • Better Than a Search B...

Пікірлер: 11

@hinata6757 2 ай бұрын

Hi can you help me. I want to have a search bar to search for employee ID and search date from and date to at the same time. Once I click the search button, the data will then be displayed to a table like displaying my selected rows from the other tables. and the main problem is, there is a static data below the table and my problem is that what if I reach the number of rows I alloted to the searched data? and what will then be happen to the remaining data I need to display

@ParkerLearnsStuff 2 ай бұрын

For more complex search functions, see my other video. kzfaq.info/get/bejne/frueec6LtaiWmYU.html

@dianabeatrizturpoaro2651 5 ай бұрын

Gracias❤❤❤

@mizanc9 4 ай бұрын

Thanks

@OSCARPION09 2 ай бұрын

What if you have multiple tabs? (Example: Data1, Data2, Data3) How can you search in all tabs? Thank you.

@ParkerLearnsStuff 2 ай бұрын

You would have to repeat this process for each tab. This can become quite time consuming. This is why I created an app script that you just have to copy and past and instantly your entire sheet is searchable. You can find my video here: kzfaq.info/get/bejne/frueec6LtaiWmYU.html

@NovemberRainE 2 ай бұрын

How do you switch between sheets to select the columns?

@ParkerLearnsStuff 2 ай бұрын

As you are filling in the requirements for the filter function, you have to designate the data range. You can accomplish this by manually entering or highlighting. In this case, I clicked the other sheet, and the while holding down the control or command key selected the entire rows I wanted to highlight. This updates the data range. Hope that helps.

@varuncd1096 3 ай бұрын

I am trying this with clients' name in a row. But, it's not working. Please suggest something.

@ParkerLearnsStuff 3 ай бұрын

Likely not searching the correct word. If you for example have one column for first name, another column for last name, you can only look up via first or last not both. If you need a more universal look up, I suggest watching my other video. kzfaq.info/get/bejne/frueec6LtaiWmYU.htmlsi=X6OlpdbX4xpjH7Iy

@varuncd1096 3 ай бұрын

@@ParkerLearnsStuff Yes, it is working. Actually, I was trying something similar, later realize it was not correct. Thank you.