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
@dianabeatrizturpoaro26516 ай бұрын
Gracias❤❤❤
@mizanc95 ай бұрын
Thanks
@OSCARPION093 ай бұрын
What if you have multiple tabs? (Example: Data1, Data2, Data3) How can you search in all tabs? Thank you.
@ParkerLearnsStuff3 ай бұрын
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: kzbin.info/www/bejne/fobRd56Qhadln7M
@hinata67573 ай бұрын
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
@ParkerLearnsStuff3 ай бұрын
For more complex search functions, see my other video. kzbin.info/www/bejne/fobRd56Qhadln7M
@NovemberRainE3 ай бұрын
How do you switch between sheets to select the columns?
@ParkerLearnsStuff3 ай бұрын
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.
@varuncd10964 ай бұрын
I am trying this with clients' name in a row. But, it's not working. Please suggest something.
@ParkerLearnsStuff4 ай бұрын
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. kzbin.info/www/bejne/fobRd56Qhadln7Msi=X6OlpdbX4xpjH7Iy
@varuncd10964 ай бұрын
@@ParkerLearnsStuff Yes, it is working. Actually, I was trying something similar, later realize it was not correct. Thank you.