Beautifully presented - precise, clear, concise! Very much appreciate your direct and fast implementation - so much easier than dozens of other videos! And a very useful, simplified method. Will definitely be looking forward to all your posts! Thank You!
Lots of goodies in this presentation: (1) ActiveX gave you dynamic abilities, (2) Good use of "New Rule" in conditional formatting, (3) filtering using multiple criteria, (4) Nice use of paste while keeping column widths. Thanks. You got a new subscriber. 😁
I have seen quite a few of these videos on adding search boxes this is the first one that i was able to follow without tuning out. You covered exactly what I need done which is to search a table but return only some of the columns.
Thank you. These are Exceptionally good clear explanations. Can a form be created that would use a combo box with this type of multi column fuzzy type search? Also it was nice to see in a normal video instead of a short.
I appreciate it! That's a great question. Do you mean you want the results to be displayed in a combo box? If that's the case, you might need to use VBA code to populate the combo box.
@@RebekahOster Yes in a combobox on a form that will allow a search just like you show in the video. I looked at all your videos but didn't see anything like this. How about making one to show how?
Rebekah Oster- you are an amazing teacher .. you made this so easy to understand. I just did this for a spreadsheet at work and it came out great.. Thank you, looking forward to your other teachings
I’ve been on the hunt for implementing what I envisioned Excel to be able to do! You nailed it. I do wish, however, that the search bar could be on the same sheet as the data and just filter that set of data vs creating another table elsewhere.
Nice clear tutorial. I done a similar search like this (but not with a fancy searchbox) and used the column headers in the search page to tell the choosecols function what to use,using Match function to get the column number.
I’m so glad it was helpful! My goal is to share the most useful methods to make your spreadsheets shine 🎉. I have a free training here: www.excelpowerup.com/training
This was so helpful. I have been trying to catalog our flower beds by location and this helped us find a specific plats location. Now if I can figure out how to display the photo of the plant it would be perfect.
Great job!! I’m so glad this video was helpful. I have another video about adding photos to your spreadsheet: ruclips.net/video/EO9Xxctq11Y/видео.htmlsi=CdgtF17DwJHz0Aua . If you added a column for each “Plant Photo”, it should pop up when you do the search. Best of luck to you!
Hi, Rebekah! I like your video so much I will use this idea in my spreadsheet. Can I ask about filter function errors when nested with choosecols? I have one with if empty part not working because of choosecols.
Very interesting. I like the way you explain the formulas. I’m not great with nesting formulas, but your explanation really helped me. I may use a search box to allow my team to pull data quickly from customer alert data based. I’ll have to think this through carefully. (And watch this clip 10 more times.) 😂 BTW, you earned a subscribe from me and I’m stingy with subscribing to Excel channels.
You got a new subscriber here. The best tutorial so far on the subject of Dynamic Search Bar. I am wondering if you could add an additional upgrade - ie. to return a data in School Name wherein the original data of school name is a hyperlink to its website. That is the School Name is an active URL. Will it possible to return the same in the result of a dynamic search?
I literally have spent 3 hours looking other search box tutorials and each failed and took forever, I came upon yours and in 14 minutes it was done and dusted perfectly. thank you for that, you are absolutely awesome.
Wow great job!! I love finding the easiest and best ways to improve your spreadsheets! For more, check out my masterclass here: www.excelpowerup.com/training 🥳
Thank you very much for your beautiful, simple and wonderful explanation. This is really the first time I have learned this information from you. I have a question, what kind of version of Office is this? Thank you very much.
Excellent video! I have an issue with the 'Text Box'. I made the search bar but after I click on the 'Design Mode' to deactivate it and enter text in the activeX text box, the cursor does not show. I type and no text appears in the Text Box. I can see the text typed into this box show on the 'LinkedCell' but not within the actual Text Box. I'll be grateful for any help.
Nice, thanks for sharing. Would you have any ideas on how to make this with multiple selections (without VBA, i.e. macro's disabled) similar to a slicer with multiple selections. When you use a slicer with multiple selections defined on a long data set/list you easily miss the overview of all your selections...
really enjoyed this video. very informative. question if one of the col contains a number value. is there anyway to get a total value for that row to display at bottom. thanks in advance.
Hi Rebekah, I appreciate your clear explanation in this video. It was very helpful and informative. I have a question for you. How can I search for data in multiple worksheets in the same workbook, if the headers are not in the same order as in one sheet? Is there a way to do this easily? Thank you for your time and assistance.
Hello! This sounds like quite a challenge. My first idea is to create an intermediate sheet where you combine all of the data into one table and search from there. If you need help with this, you can schedule a call with me here: www.excelpowerup.com/offers/SJPzr8fY . Thanks for watching!
Thank you so much!! Yes! There are two ways I can think of to do this. The first is to create an intermediate sheet that combines all the sheets you want into one mega table. Use the VSTACK function or PowerQuery to do this so that it is dynamic and reflects any changes to the original sheets. Then the FILTER function would reference that intermediate table. The other option is to create multiple FILTER functions (one for each sheet), and stack those together with VSTACK in the search results area. This would be a mega-huge function!
That's so great!! I'm sure there is. I would test out the TAKE function. It lets you choose a specific number of rows or columns to return from an array 😀
Fantastic video! I manage a large club membership database on Excel and have followed these instructions to add a seach function to the surname and postcode column of the members listed and i can find members details very easily with your method, however, I would like to be able to edit the members details that results from a search. Is this possible?
Wonderful!! Unfortunately, with this method the information flows only one way. A work around is to add a column that will contain a link to the row you are looking at in the database. Here is an article that can help with that: www.exceldemy.com/excel-cell-function/ Let me know if you would be interested in a video about this!
Great tutorial for a dynamic search field for excel. Thank you. Question: how would you go about creating a search field with more dynamic functionality where the search is focused on one column and is searching multiple words in the column. The search may not follow the actual order of the words in the field but needs to return the lines with all the words that are being searched. Example: If I type "pipe, pvc" or "pvc, pipe" in the search field, the result should return the result as shown below. Is this achievable? Thanks in advance. Search: pipe, pvc result: PIPE, 30", GRAY, PVC YELLOW, 25", PIPE, PVC PIPE, BASE, RACEWAY (CHANNEL), PVC, OFF-WHITE, 2.38 X 0.73 INCHES X 10 FEET
I have built an address book using your video. Everything worked very well so thank you very much for the video. I have identified one problem. If I enter a search term that is not found, the text is displayed as determined in the formula. But this only works if you omit the formula "CHOOSE.COLS". If you use the "CHOOSE.COLS" function, it will no longer work! The filtering of the columns works perfectly, but if you enter a search term that does not exist in your table, you will receive an error message "VALUE". To be clear, without the "CHOOSE.COLS" function it works as it should. Any idea how this happens? Thanks a lot in advance. Kind regards
Great video! Question - I followed the instruction but something does not work ("there is a problem with the formula"). I think the derived from the table name - when I write it + [, the columns list does not open. Any idea hoe to fix this? Thanks
Brilliant I have a large database of my cd compilations and this works so well for me many many thanks. Now I have just have to import a version into access.
Hello Rebekah, thank you so much, this is what I need. For some reason why my search box became bigger, and font became smaller every time I entered. I have no idea why.
Hi! Thanks for your question 🙂 Wrap this around the current formula: IF(B2="","", ) I've discovered that the ISBLANK function doesn't work for this, so you have to use ="". Let me know if it works!
Hi there! Do you mean you only want to retrieve some of the columns from your data? In this video, the last example at 12:26 explains how to do this. Let me know if you had something else in mind 🙂
Thank you! What if the Name of the school and primary contact email address were on a second tab. How could a search bar on the primary sheet "pull through" second tab details like the email address by entering the name of the school?
Amazing. Works like a charm. The only thing that didn't work for me was including more columns in the search, it's telling me I can't have more than two. But that's all I need anyway.
everything in the tuttorial is very useful but i have a problem that excel 2021 doen't have CHOOSECOLS function , any walk around to overcome this problem?
It's what I was looking for, but my table has one column with hyperlinked text. Is there any way to carry that hyperlink over? Second item, is there a way to have a default text in the search field like "click here" that disappears when it's clicked or is that a product ofVBA only? It's just that I don't want to display the whole table by default, I'd like it to show zero results when someone opens it. Thanks muchly!
Hi, thanks for this video. It's awesome. I tried using the dynamic search, and did exactly what you did, but for some reason the cursor doesn't show in the search box. The search actually works but I cannot see what I'm typing. I can only see what I typed after a click away from the box, anywhere in the sheet. It is weird because the search actually works and I can see the data moving or searching, but I cannot see what I'm typing. Can you help? thanks so much
Hi! That stinks that you were having this problem. I did a little searching online and found that it does not seem to be a problem with Excel itself, but is more likely to be related to your graphics card or any external monitor that you may be using. I suggest you try it out on a different computer if you have access to one!
Around 5:38 you began typing text into your textbox. When I try doing this, the cursor icon does not show up and the text is not shown autopopulating in real time when I type. Only when I hit enter does the text show up, so something is clearly wrong with the textbox settings, but I have no idea what that is.
If your source data does not have values in all cells, just add & "" after the FILTER (or CHOOSECOLS) function to force returning empty strings instead of zeros. If you want to use the conditional formatting, you may want to change that into & " " (whitespace character), and that way the formatting should draw those lines around those cells as well. I have yet to figure out how to lock that search bar in place, as it appears to be impossible to group a control and graphics together so that they would also move together. I suppose, one would want to lock the entire sheet meant to be used for searching (Review > Protect Sheet)...
Replying to my own comment, huh... This whole thing is still notably less useful than the built-in search (CTRL + F), which shows you where in the results the substring is found. If this solution could highlight the string in result rows, or at the very least the cells that contain the matching string, then this would have some useful applications over the built-in function (as a more visual alternative).
How do I narrow the isnumber I am looking for a location which are assigned numbers 1 to 38. In my search I type 1 and I get 1,11,12,13,14,etc when all I want is location 1 for example
Hello! How can I search multiple words into " Search bar " ? I need to put more than one word in " Search bar". Thank you for your info. that your shared with us!
Try using an asterisk (*) as a wild card value to separate your search words. For instance word1*word1 Caveat to this is that both words would have to be in the same cell and would need to be in the order you placed then in the search
Thanks so much, Rebekah! I did encounter one bug. The text in my search box continually shrinks every time I click out of it. The only way I've been able to fix that is by toggling design mode and changing the size of the box. Otherwise, the text inside the search box shrinks until it's no longer visible. Is there any way to fix that?
Hey! I’m so glad you tried out this tutorial, but I’m sorry that you had an issue! I tried to figure out why that could be happening and I couldn’t replicate it. For more personal help, schedule a call with me here: www.excelpowerup.com/offers/SJPzr8fY Thanks for watching!
Have you run into this issue yourself? My understanding is that the elements I used in this search box are not macros; they are form controls. Obviously, no solution works for everyone!
I checked the solution. Excel warns that there must be a VBA workbook, but allows saving without. And everything works. So I apologize for the inaccurate comment.
you know it well and explain simply ;that's what smart teachers do.
Wow what a compliment!!
I have watched several videos on this topic and all presented error in implementation, until this one. Great job! Thank you for sharing.
I really appreciate that!
Beautifully presented - precise, clear, concise! Very much appreciate your direct and fast implementation - so much easier than dozens of other videos! And a very useful, simplified method. Will definitely be looking forward to all your posts! Thank You!
Thanks so much! Stay tuned 🙂
Lots of goodies in this presentation: (1) ActiveX gave you dynamic abilities, (2) Good use of "New Rule" in conditional formatting, (3) filtering using multiple criteria, (4) Nice use of paste while keeping column widths. Thanks. You got a new subscriber. 😁
I appreciate it! You sound like an experienced Excel user 😏 Welcome!
Hello, I'm from Brazil. This video helped me to study English and Excel. Thanks.
Good tips and clear descriptions
I have seen quite a few of these videos on adding search boxes this is the first one that i was able to follow without tuning out. You covered exactly what I need done which is to search a table but return only some of the columns.
Wow what a compliment!! Thank you for watching 😀
This was so helpful, thank you!
Thank you. These are Exceptionally good clear explanations.
Can a form be created that would use a combo box with this type of multi column fuzzy type search?
Also it was nice to see in a normal video instead of a short.
I appreciate it! That's a great question. Do you mean you want the results to be displayed in a combo box? If that's the case, you might need to use VBA code to populate the combo box.
@@RebekahOster Yes in a combobox on a form that will allow a search just like you show in the video.
I looked at all your videos but didn't see anything like this. How about making one to show how?
Thanks for the idea!! I'll add it to my list 😀
best video I've seen on this subject! And it worked out -of-the-box. No struggle trying to discover why it wasn't working.
You made SEARCH filtering with selective columns so easy, thanks for transferring knowledge.
I like this video ❤❤❤❤
I appreciate it!!
This is so insightful and you were very explicit. Learned a lot. Thanks so much for sharing.
Thank you for your feedback! Have you seen my free training? Excelpowerup.com/training ❤️
Rebekah Oster- you are an amazing teacher .. you made this so easy to understand. I just did this for a spreadsheet at work and it came out great.. Thank you, looking forward to your other teachings
That's so wonderful!!
Awesome, so much knowledge in one video
Glad you liked it!
I’ve been on the hunt for implementing what I envisioned Excel to be able to do! You nailed it. I do wish, however, that the search bar could be on the same sheet as the data and just filter that set of data vs creating another table elsewhere.
Nice clear tutorial. I done a similar search like this (but not with a fancy searchbox) and used the column headers in the search page to tell the choosecols function what to use,using Match function to get the column number.
Wow that's a really cool approach!! Very dynamic 😀 And it would be easy for other users to change.
YOU DESERVE AN EXCEL OSCAR AWARD.
Really clear and will definitely use this
Thanks so much! What kind of spreadsheet do you have in mind?
Great demonstration, for a Newby this was so easy to follow and well explained..
Wonderful and very easy to understand, not so much complicated.
Very, very useful. And so well-presented. You've got a new subscriber!
Welcome aboard! Thank you :)
Definitely gonna play around with this! There are certain functions at work that could be drastically improved with this!
Wow. I learned so much watching this. Thank you!
Yay! 🎉
Thank you Rebekah, great example and video 😘
You are so welcome! I’d love to hear if you tried it out 😁
Very useful and advanced, yet simply explained. Well done. Thank you
Thank you. We need more of your educative tutorials
I’m working on them! I have a free masterclass with great content here: www.excelpowerup.com/training
Adding a lineshift in the formula was helpful, a new trick i didn't know about. Thanks for a great tutorial
I’m so glad it was helpful! My goal is to share the most useful methods to make your spreadsheets shine 🎉. I have a free training here: www.excelpowerup.com/training
I have learned so much from you thanks
Easy to follow, thank you and something I can use.
That's wonderful!! What kind of spreadsheets are you working with?
Birlliant and very simple, its very helpful and I solve this search with the help of your video. Thank you so much
This was so easy to follow!! You have a great pace and way of explaining!
Thank you so much! Have you signed up for my masterclass? www.excelpowerup.com/training 🎉
Helpful above the satisfactory level! Best ever video on the topic I have seen. Thank you very much.
This is great! One question, how do I make sure that my hyperlinks transfer across to the search bar page too?
This was so helpful. I have been trying to catalog our flower beds by location and this helped us find a specific plats location. Now if I can figure out how to display the photo of the plant it would be perfect.
Great job!! I’m so glad this video was helpful. I have another video about adding photos to your spreadsheet: ruclips.net/video/EO9Xxctq11Y/видео.htmlsi=CdgtF17DwJHz0Aua . If you added a column for each “Plant Photo”, it should pop up when you do the search. Best of luck to you!
Hi, Rebekah! I like your video so much I will use this idea in my spreadsheet. Can I ask about filter function errors when nested with choosecols? I have one with if empty part not working because of choosecols.
Yes, as soon as I add CHOOSECOLS function it throws #value instead of "No Schools found" ... Anyone found a solution for this. Thx
It works for me. Thank you Rebekah for this tutorial. Very helpful without VBA coding (I wish I can), I can get the needed results quickly.
That's wonderful! Great job!!
Very interesting. I like the way you explain the formulas. I’m not great with nesting formulas, but your explanation really helped me. I may use a search box to allow my team to pull data quickly from customer alert data based. I’ll have to think this through carefully. (And watch this clip 10 more times.) 😂 BTW, you earned a subscribe from me and I’m stingy with subscribing to Excel channels.
This is the best video. Thank you so much.
Glad you liked it!
This was very helpful! Thank you. 👍🏻👍🏻
Glad it was helpful!
This was excellent - thank you.
I appreciate it! Do you have a spreadsheet that could use a search box?
Nice. Hadn't thought of implementing instant search this way. You earned a sub!
I love your tutorials so much that I've liked and added a follow.
Wow that means so much! Thank you!!
You got a new subscriber here. The best tutorial so far on the subject of Dynamic Search Bar. I am wondering if you could add an additional upgrade - ie. to return a data in School Name wherein the original data of school name is a hyperlink to its website. That is the School Name is an active URL. Will it possible to return the same in the result of a dynamic search?
I literally have spent 3 hours looking other search box tutorials and each failed and took forever, I came upon yours and in 14 minutes it was done and dusted perfectly. thank you for that, you are absolutely awesome.
Wow great job!! I love finding the easiest and best ways to improve your spreadsheets! For more, check out my masterclass here: www.excelpowerup.com/training 🥳
Thank you very much for your beautiful, simple and wonderful explanation. This is really the first time I have learned this information from you.
I have a question, what kind of version of Office is this? Thank you very much.
Wow, you made that look so easy, thanks for the great tutorial
I'm so glad! 😀
Thank you so much, I watched lot of videos about his topic but you are the best best best and easiest to understand ......
That is so kind! Thank you very much 🎉
Very simple and straight forward video. Liked and subscribed. Thank you.
🎉. In an ideal universe we could use the filters in combination with this filter. Could we?
Excellent video!
I have an issue with the 'Text Box'. I made the search bar but after I click on the 'Design Mode' to deactivate it and enter text in the activeX text box, the cursor does not show. I type and no text appears in the Text Box. I can see the text typed into this box show on the 'LinkedCell' but not within the actual Text Box.
I'll be grateful for any help.
this was amazing !!! simple, concise, and very useful #new sub
So happy that you found it useful!
Thanks a lot!!! Most of tutorial that i found, this video the one that actually work on me🎉 thank you soo much !!!
You are so welcome!! Have you seen my free training? www.excelpowerup.com/training 🎉
I can't thank you enough. You are a great Excel tutor
Thank you so much! 🥳
Nice, thanks for sharing. Would you have any ideas on how to make this with multiple selections (without VBA, i.e. macro's disabled) similar to a slicer with multiple selections. When you use a slicer with multiple selections defined on a long data set/list you easily miss the overview of all your selections...
really enjoyed this video. very informative. question if one of the col contains a number value. is there anyway to get a total value for that row to display at bottom. thanks in advance.
Amazing tutorial, keep it up, you will soon rock
Hi Rebekah, I appreciate your clear explanation in this video. It was very helpful and informative. I have a question for you. How can I search for data in multiple worksheets in the same workbook, if the headers are not in the same order as in one sheet? Is there a way to do this easily? Thank you for your time and assistance.
Hello! This sounds like quite a challenge. My first idea is to create an intermediate sheet where you combine all of the data into one table and search from there. If you need help with this, you can schedule a call with me here: www.excelpowerup.com/offers/SJPzr8fY . Thanks for watching!
the best suggested video i got so far.
Haha that’s awesome!! Have you seen my free training? www.excelpowerup.com/training 😁
Hi Rebekah, very nice tutorial on filter function! 👍
Just a question- Is the filter function applicable to multiple sheets in a same file?
Thank you so much!! Yes! There are two ways I can think of to do this. The first is to create an intermediate sheet that combines all the sheets you want into one mega table. Use the VSTACK function or PowerQuery to do this so that it is dynamic and reflects any changes to the original sheets. Then the FILTER function would reference that intermediate table.
The other option is to create multiple FILTER functions (one for each sheet), and stack those together with VSTACK in the search results area. This would be a mega-huge function!
Great tutorial and explanation. 🙏🏾🦾❤️
Awesome. Definitely going to use this. Thanks
You saved my day. Really helpful
By far the best solution I found on excel and it worked . Is it possible to populate just one row instead of all of them in the sheet with out VBA?
That's so great!! I'm sure there is. I would test out the TAKE function. It lets you choose a specific number of rows or columns to return from an array 😀
Fantastic video! I manage a large club membership database on Excel and have followed these instructions to add a seach function to the surname and postcode column of the members listed and i can find members details very easily with your method, however, I would like to be able to edit the members details that results from a search. Is this possible?
Wonderful!! Unfortunately, with this method the information flows only one way. A work around is to add a column that will contain a link to the row you are looking at in the database. Here is an article that can help with that: www.exceldemy.com/excel-cell-function/
Let me know if you would be interested in a video about this!
@@RebekahOster Thanks for the reply and the link. A video relating to my question would be fantastic and save me a lot of head scratching.😉
Great tutorial for a dynamic search field for excel. Thank you. Question: how would you go about creating a search field with more dynamic functionality where the search is focused on one column and is searching multiple words in the column. The search may not follow the actual order of the words in the field but needs to return the lines with all the words that are being searched. Example:
If I type "pipe, pvc" or "pvc, pipe" in the search field, the result should return the result as shown below. Is this achievable? Thanks in advance.
Search: pipe, pvc
result:
PIPE, 30", GRAY, PVC
YELLOW, 25", PIPE, PVC
PIPE, BASE, RACEWAY (CHANNEL), PVC, OFF-WHITE, 2.38 X 0.73 INCHES X 10 FEET
Hi it's cool, you can use VSTACK for the headers instead of manually deleting 😮
Very well explained and thanks!
I appreciate it! I would love to hear how you would use a search box in your spreadsheet 😀
I follow step by step and it worked. Thank youu
Woot woot! You are so welcome 🤗
I have built an address book using your video.
Everything worked very well so thank you very much for the video.
I have identified one problem. If I enter a search term that is not found, the text is displayed as determined in the formula.
But this only works if you omit the formula "CHOOSE.COLS". If you use the "CHOOSE.COLS" function, it will no longer work!
The filtering of the columns works perfectly, but if you enter a search term that does not exist in your table, you will receive an error message "VALUE".
To be clear, without the "CHOOSE.COLS" function it works as it should.
Any idea how this happens?
Thanks a lot in advance.
Kind regards
Very helpful thank you
Great video!
Question - I followed the instruction but something does not work ("there is a problem with the formula").
I think the derived from the table name - when I write it + [, the columns list does not open.
Any idea hoe to fix this?
Thanks
THANK YOU SO MUCH, I WANT TO ASK HOW CAN WE EDIT, FOR EXAMPLE STUDENT ID ON THE SEARCH WORKSHEET TO TAKE EFFECT ON THE DATA/TABLE WORKSHEET😁
I appreciate your comment! That would require a lot more work, and probably VBA code. I'm sorry, it's not a simple thing!
Brilliant I have a large database of my cd compilations and this works so well for me many many thanks.
Now I have just have to import a version into access.
Hello! I'm so glad it works for you! Thanks for watching and commenting 🙂
Hello Rebekah, thank you so much, this is what I need. For some reason why my search box became bigger, and font became smaller every time I entered. I have no idea why.
Hi! Is it possible you are in "Design Mode"? There is a toggle button for Design Mode on the Developer tab.
Hey, Rebekah Thanks for the video. pl suggest how to avoid seeing entire table when there is no value in search bar.
Hi! Thanks for your question 🙂 Wrap this around the current formula:
IF(B2="","", )
I've discovered that the ISBLANK function doesn't work for this, so you have to use ="".
Let me know if it works!
@@RebekahOster Thanks Rebekah. It is working.
Thanks, if I want only some of the headers in the search, what should I do?
Hi there! Do you mean you only want to retrieve some of the columns from your data? In this video, the last example at 12:26 explains how to do this. Let me know if you had something else in mind 🙂
Awesome explanation. Thank you :)
You're very welcome! 🎉
Hi. What about if you need to edit something on the table that will automatically save to the Main table?
Thank you! What if the Name of the school and primary contact email address were on a second tab. How could a search bar on the primary sheet "pull through" second tab details like the email address by entering the name of the school?
Amazing.
Works like a charm. The only thing that didn't work for me was including more columns in the search, it's telling me I can't have more than two. But that's all I need anyway.
I'm glad you were able to get it to work!!
@Rebekah Oster if I want to use multiple tabs, can we use the same formula?
Yes! If you use structured references like I demonstrate, it should be very easy.
everything in the tuttorial is very useful but i have a problem that excel 2021 doen't have CHOOSECOLS function , any walk around to overcome this problem?
You can just leave it out, and the function will return all the columns from the database. Then just hide the columns you don't want to see!
It's what I was looking for, but my table has one column with hyperlinked text. Is there any way to carry that hyperlink over?
Second item, is there a way to have a default text in the search field like "click here" that disappears when it's clicked or is that a product ofVBA only? It's just that I don't want to display the whole table by default, I'd like it to show zero results when someone opens it.
Thanks muchly!
I have data containing numbers only can this wroks too ?
رائع جدا برنامج عظيم .
Very nice project great .
Great tutorial. Many thanks.
Hi I love your search box I am looking for a way of searching data then have the ability to edit data can you help
Hi! I would make sure your data is an Excel Table and use the built in Filter buttons on the columns. 👍
GREAT !!!
THANKS ....
Can I have your file, so Excel translates the formulas to Dutch format ??
Hi, thanks for this video. It's awesome. I tried using the dynamic search, and did exactly what you did, but for some reason the cursor doesn't show in the search box. The search actually works but I cannot see what I'm typing. I can only see what I typed after a click away from the box, anywhere in the sheet. It is weird because the search actually works and I can see the data moving or searching, but I cannot see what I'm typing. Can you help? thanks so much
Hi! That stinks that you were having this problem. I did a little searching online and found that it does not seem to be a problem with Excel itself, but is more likely to be related to your graphics card or any external monitor that you may be using. I suggest you try it out on a different computer if you have access to one!
Around 5:38 you began typing text into your textbox. When I try doing this, the cursor icon does not show up and the text is not shown autopopulating in real time when I type. Only when I hit enter does the text show up, so something is clearly wrong with the textbox settings, but I have no idea what that is.
If your source data does not have values in all cells, just add & "" after the FILTER (or CHOOSECOLS) function to force returning empty strings instead of zeros. If you want to use the conditional formatting, you may want to change that into & " " (whitespace character), and that way the formatting should draw those lines around those cells as well.
I have yet to figure out how to lock that search bar in place, as it appears to be impossible to group a control and graphics together so that they would also move together. I suppose, one would want to lock the entire sheet meant to be used for searching (Review > Protect Sheet)...
Replying to my own comment, huh...
This whole thing is still notably less useful than the built-in search (CTRL + F), which shows you where in the results the substring is found. If this solution could highlight the string in result rows, or at the very least the cells that contain the matching string, then this would have some useful applications over the built-in function (as a more visual alternative).
Thank you so much a great help 😊
I’m so glad you found it useful! I have a free training you might like here: www.excelpowerup.com/training 🎉
Thank you so much madam. But if I want to search by all columns value what will be the formula. Please help me
thank you. this is helpful
That’s great to hear! Thank you for watching 😁
Hi Rebekah. Can I use this using pivot tables?
Hi there! I'm not sure exactly what you mean. Do you want to be able to search the Pivot Table results?
How do I narrow the isnumber I am looking for a location which are assigned numbers 1 to 38. In my search I type 1 and I get 1,11,12,13,14,etc when all I want is location 1 for example
Hello! How can I search multiple words into " Search bar " ? I need to put more than one word in " Search bar". Thank you for your info. that your shared with us!
Try using an asterisk (*) as a wild card value to separate your search words. For instance word1*word1
Caveat to this is that both words would have to be in the same cell and would need to be in the order you placed then in the search
This is exactly right! Thank you for sharing ❤️
Amazing!!
Thank you so much!!
Thanks so much, Rebekah!
I did encounter one bug. The text in my search box continually shrinks every time I click out of it. The only way I've been able to fix that is by toggling design mode and changing the size of the box. Otherwise, the text inside the search box shrinks until it's no longer visible. Is there any way to fix that?
Hey! I’m so glad you tried out this tutorial, but I’m sorry that you had an issue! I tried to figure out why that could be happening and I couldn’t replicate it. For more personal help, schedule a call with me here: www.excelpowerup.com/offers/SJPzr8fY
Thanks for watching!
It works only with macro enabled workbooks. There are some problems with that because a lot of companies doesn't allow macros.
Have you run into this issue yourself? My understanding is that the elements I used in this search box are not macros; they are form controls. Obviously, no solution works for everyone!
I checked the solution. Excel warns that there must be a VBA workbook, but allows saving without. And everything works. So I apologize for the inaccurate comment.