🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ru-vid.com/group/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
This is one of those times that being self-taught is a detriment. I had no idea this function was even available, so I’ve always just used control+F and then tabbed through the results. Having it show the results in a table will be very helpful. Saved this one and will definitely be trying it. Thank you!!!
I also felt the need to be self taught though when so many teachers want to turn this into a $200 course that lasts months when we could learn it in 2 weeks with Kevin.
Great teacher ! Thank you very much Kevin for your hard work and all the data sample which saves us a lot of time to prepare. I love your lessons, very helpful, easy to understand with your clear voice and well prepared tutorials.
Well of course I can't choose one cookie because I love every type. But I can choose my favourite RU-vidr. It is you. And you are also the first channel that I subscribed to right after I started watching RU-vid videos. I am just excelling in Excel and now I am the smartest. Nah! Just kidding. YOU ARE LITERALLY THE BEST.
Hey Kevin. Microsoft has removed filter function from all versions except office 365 subscrbtion. Kindly make a video on building search box without that. That will be very helpful. Thanks
Omg this was racking my brain for ages! The initial basic serch worked fine but the stsps after that werent! I went over and over then though "ill just keep following and see what happens" by the finzl step, it all worked!!! Over the moon!!!!
This is one of the most ingenius solutions made possible in Excel! Thanks! I'm trying to take it a step further. To be able to search on more than 1 keyword, just like the way an HTML search engine would work. I did some researching on the internet. I think you need to make it work by adding additional search boxes and link those search boxes to separate cells and add references to those separate cells into the one formula. But somehow I can't figure out how to make it work so I only get the results based on all multiple criteria.
Thank you so much for this very clear tutorial! It's gotten me much closer to the functionality that I need. Is it possible to use this formula to search across multiple sheets within a workbook?
Say you have a large table and only want to return a few of the columns? Say only last name + favorite cookie Maybe one from the beginning would be good. Making the 2 tables and all. I am making a spreadsheet at work and I need help with this search function! Great video I'll apply what I learned tomorrow. But I'll still need to fine tune I think. Thanks again
Hey Kevin, your tutorials have been very helpful for me in trying to find some simple ways to work with excel. :) I have a question regarding the Search function. Can we COMBINE Multiple words in the search bar when typing the text? like for example --- Search - Kevin Chocolate :) THen returns value in the table that matches those.
Thanks Kevin. It's very useful video. I came across this right time when I am looking for keyword analysis related formulas in excel. It's not completely address my requirement but quite useful to carryout my work.
I only used Find button in the ribbon if I want to find something. It can cover the who tabulation names. However it is cool to know that it is possible to do the same thing in a different way
@@TechTeacherTT thanks for the input. My apologies for not being clear. What I actually need is a search combo box, where as I type, I can see the matches and select 1 option
@@justingill9822 I would try something like this. As you type in your filter query, the results display. Test the cells for the search string. Make a list of the UNIQUE values in a table that match the query. Make the list available in the dropdown list. I can't flesh it out any more than this as my excel doesn't even have the FILTER fn and googlesheets doesn't allow the use of the textbox like this. Hope this gives you a clue. I know you can make dynamic values, maybe you need one of those in the VBA
Thank you very much! This was helpful, the only issue i have and i hope yoy can help is now the entire table shows as results if the search box is blank! How do i disable this, i need this to show no datq if the search box is blank. Thank you again
Hi Kevin, the tutorial video is really helpful. I also tried creating a searh box. But in the search results links provided in the actual table are not getting copied/appeared. I wonder is it possible to make it that way. I want make search box for a list of sites with the liks attached to the cells in the reference table.
Thank you kevin for this trick. Bu i want to know if i can get results to my filter in the main data itself? instead of the other table which you did in the right hand side. I want to get my filter result in the main data table itself. Please let me know if anyone knew this.
Hello Kevin your video is so useful but if you could guide me for an advance excel like you just give an example if I have data in sheet 1 and want the search box in the same sheet, But I am trying building dynamic excel dashboard where I if I would search in sheet 2 the data reflect in the sheet 2
I love your videos. Several of them have answered questions I couldn't get answered otherwise. I do have one question though. I used your search tool from "How to Build Search Box in Excel" and it works great with one exception. When the data source has some unique formatting (colored text or bolded text or other stuff like that) is only copies over the raw text, no formatting. Is there a way to keep the formating?
HI Kevin, in the case of a long string of text in a column with up 10-12 words, how would you modify the search box to show results that containtmultiple words in it? Say if we have cells that contain Name+CIty+Cookie+Age etc., find all matches that contain both of the words Chocolate and 13, to see all people that are 13 and like chocolate cookies. This is for a case, where multiple conditions (in this case partial matches for multiple words) have to be met. Hope you get time to answer this, would be very helpful. Thank you in advance.
Hey Kevin, Love your tutorial. I have been using Excel.Mac 2011. Having some trouble finding tools as shown in your screen. In starting, which button do i use instead of text box in developer mode?
Hey Kevin, that a very helpful video. Just what im currently looking for. Quick Question Im trying to make a supplier database but some of the cells have information separated by comas, will this search box work the same? Any video you recommend to watch to help me making my supplier database?
Hi, Thank you so much for your efforts in creating this video and sharing, God Bless you. When the Selected Table Cell is blank the filter returns the value as "0" how to remove "0" and keep the cell blank? I tried Iferror but it did not work.
I love your search box youtube. The issue I have is how do I take a copy of my spreadsheet with a working search box and give it to someone else to use. I have looked all over and cannot find out how to do that. I would love to be able to email it but I would settle for having to send it on a USB Stick. Is that possible?
Hi Kevin. I love this search box, but i had one problem when a tried to apply in my tables. The result not contain different in upper and lower cases (If data is written as ORANGE, the result not find if I type Orange in the SearchBox). How can I fix it?
Thank you very much for this!! I have a question, is there a way we can copy the search results? Example: I use the search function, I get the result and I want to copy the text within that cell result. Thank you!
Kevin I followed everything you did, but when I type in my search box nothing shows up until I click on another cell then it will show what I type in the cell behind the box. Is there something in the property I need to change ?
hi love you work, unrelated question, excel work book that contains around 30 tabs, i beleive theres away to build a control key to open a tab dialog box ? is this correct?
Great tutorial, is there a way to enter changes to the search results (name or phone number), so it updates/supplements the data of the existing list? like a database