How to Build Search Box in Excel

[@KevinStratvert]

🏫 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: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@shema7202]

Hi @Kevin Stratvert can you help me creat dis kind of dashboard please

[@danemmerich6775]

Being Self Taught as well, i have to watch this Video many times to really get it where it sticks. You are the man Kevin! So smart!

[@katrinahernandez8201]

As an easy way to reference a larger number of columns select the area you need and use the create from selection option under formulas. Use the top row option to name them in bulk and tweak the reference to include the first row. Thanks for the tutorial!

[@texasseastar]

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!!!

[@cwjakesteel]

Did you know that the definition of Naivete is self-taught? Your comment also reminds me to be thankful for experienced teachers in my life.

[@cwjakesteel]

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.

[@GazariZakaria]

We cant find filter function

[@chadwinter6873]

Hey Kevin, rise and shine! Your videos never fail to brighten my day, but today, I've hit a snag in Spreadsheet Land. Picture this: me, desperately searching for the elusive FILTER function, only to find out it's playing hard to get, reserved exclusively for Excel 2021 and Microsoft 365 VIPs. Talk about a plot twist! So here I am, stranded in Microsoft Office Home and Business 2019 territory, feeling like I missed the train to Spreadsheet Paradise. Any chance you've got a secret map to a search box workaround? I'm all ears! Keep spreading the spreadsheet wisdom, and thanks a million for your tireless efforts. Looking forward to your sage advice! Cheers, Chad. 🚀

[@manoftheroad55]

I was disappointed that your days are elevated by Excel and Office tutorials... Outside your glass window is a real world..Life is precious please try and enjoy every moment microsoft is not a fulfilment Reevaluate your life...

[@naqiksah93]

I wonder how much Excel sifus charge in the past for these valuable knowledge and now with KZbin we're getting it for just a meager cost of data, electricity and time. Thanks Kevin. Super helpful!

[@JustBlankNoInfo]

"How could you possibly choose one favourite cookie, but hey we had to do it" Very True! The Kevin cookie company has the most delicious cookies in the world! Your videos are proving Excel is powerful, and Indeed it is...We are marching towards 1 Million, keep going and we'll keep supporting!

[@SavageGothamChess]

Well of course I can't choose one cookie because I love every type. But I can choose my favourite KZbinr. It is you. And you are also the first channel that I subscribed to right after I started watching KZbin videos. I am just excelling in Excel and now I am the smartest. Nah! Just kidding. YOU ARE LITERALLY THE BEST.

[@firmaevents9594]

I watched it with excitment since i wait for your valuable videos. You are one of the best excel teachers. I recenlty subescribed with office 365 and iam enjoying its powerful features. Thank you alot

[@samuelwilliams8453]

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!!!!

[@mjskiee8464]

I followed the first 4 minutes but everything says "false" which results to " No records found". Im kinda frustrated cause I'm new to excel. :(

[@edkako]

Thanks!

[@KevinStratvert]

Thanks so much Ed! Much appreciated! 🙏

[@Jojosmith342]

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.

[@PremKumar-jv2ss]

Kevin is my favourite KZbinr

[@Ke-D]

Wow, u not only make it sound easy, you make it look easy too. Thanks for the video. This is the perfect thing I was looking for. Actually, I got more than I wanted. Instant subscribe.

[@thomask5649]

Your solution is great. Another top-video. Thanx Kevin. I would change the file type from xlsm (with macros) to xlsx as it doesn't contain any program code. If you don't use an active-X-control, you may use it in OneDrive or SharePoint in the Browser as well. As questioned in a comment below to check, if the search-text is at the beginning I would check the value in the search-Column I. If this is a numer and it is 1, then the searched text is at the beginning. You can do this for example in column K with the function IF in which you check the search-Result and the Number-Status. For example: =IF(J5#,IF(I5#=1,1,0),0) Include this in the FILTER-Function. Hope this helps Tom

[@paulajimenez8964]

Your videos are so good I come back again after some months!! Thank you!

[@slmstudio2839]

බොහොම ස්තූතී.... ඔයාගෙ වීඩියෝ එක ගොඩාක් ප්‍රයෝජනවත් උනා..Thank you very much... your videos are very helpful...

[@anitakusumawati9596]

I have been searching many tutorials this whole day for making the search bar for my project from so many platform and ends up with frustration because the formula always got error and I can't figure it out why, but finally I found this tutorial which is really helpful to teach me in step by step and yeay I can make it!!! .. 🎉🎉 Thank you so much

[@kwesi_AI]

Hi Kevin, I can't find the "filter" in my function on my excel workbook

[@megantaljaard1437]

Seems it's only for Office 365/2019

[@lesliebernarte2597]

I only find Filterxml on mine

[@muhammadasadullah1963]

But it's also not in excel 2019,,,,

[@UAtul]

Only in office 365

[@TheJoshtheboss]

It's only 365. I think KZbinrs should mention upfront this. As not everyone as 365.

[@scentedcherryblossom1102]

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

[@qeazit]

Hey there. You perhaps stumbled upon a solution to this?

[@BobJones-bg4ui]

@@qeazit Ditto!

[@keanalauren]

try 2021

[@danielureta5219]

On category instead of clicking most recently used click All

[@ketan031]

​@@danielureta5219FILTER option not available for me. It is showing FILTERXML option which is completely different

[@shortvidsonline98]

Is there a way to create a hyperlink with the search results? to enable navigation to another section in another sheet?

[@JustBlankNoInfo]

I never knew this was possible. This is great! This is a top-notch tutorial, loved it!

[@mdmoazzamhossain7455]

The sample spreadsheet was so helpful. Love you

[@KevinStratvert]

Glad it was helpful!

[@rossentein]

Thank you so much! This really helped me build a "Search Engine" on top of a Knowledge Base.

[@matteoubago5643]

This worked perfectly, thanks a ton! The way you say "Today" at the start of the video is hilarious btw 😂

[@BeHappy-rq9ql]

Great ...i believe in excel already filter and search options there.... But this is using formulas to do same thing... Great to know the formulas

[@Harmonicosscillation]

Glorious! Thank you, sir. You are a god amongst men.

[@vshah_03]

Wow Kevin I never noticed. You are so close to 1M subs!

[@UniqueMusicPlatformUMP]

1M subs are on the way

[@KaungHtetMyantbkk1989]

That was really good brother to sharing all your video I Irealy enjoy all your video..thnak you for your sharing..

[@techspeechplus582]

Which microphone you have used for KZbin audio recording ?

[@varaddixit8453]

Hi many thanks, I just have one question. I've data containing 2 columns: Name and "click here" Hyperlinks to folder. Can it also bring hyperlinks?

[@abdelsamada.1459]

You are theeeee best 👍👍👍👌❤️. But my excel does not support filter function! Any other way ?

[@cyberbeast1789]

good day sir! watching from the Philippines. I'd like to ask if you also a tutorial like this on the video that when customer/product is found, details of the customer will list/add/copy to another blank table? thank you..

[@PauloSilva-gs6ug]

Hi Kevin, This has helped me out so much! Could i ask if there is a way to then filter down the results given? For example, i would to only see the last five purchases for said cookie or person. Once again, thank you for this video

[@rudhraveena2638]

Kevin thanks a lot for this Tutorial....................BTW can you please make a tutorial on GIMP please🙏

[@KevinStratvert]

It's on my list! I plan to pull together an in-depth tutorial soon.

[@stephenfulmer8646]

This makes everything so much easier on the excel side for chemical engineering thank you!

[@accazita]

Really well done. Greetings from Brazil...

[@kittawanpothibut9980]

Wow, this is what I want. Thank you very much.

[@pk-solution2148]

Thank you so much, Kevin, for your helpful search box tweak.

[@ThePaskatHousussa]

Thanks! very cool, just tried it myself

[@mayankkhator3867]

Thank a lot Kevin u r brilliant....I really needed this No one can teach better than u... 👏👏👌

[@mikeellis7828]

Thank you Kevin. Very useful.

[@noppharatsua-anan7872]

Great Kevin. Thank you so much for your kindness to everyone.

[@tonyfoster8648]

Kevin is there any chance you can show how you can create a search box to search over several worksheets? Many thanks

[@kirbystarwell3701]

same question

[@namtien92]

@@kirbystarwell3701 bump

[@gajabathiarjuntg2390]

Great video Kevin.

[@harishbetrabet]

Thanks. Tried this useful tip.

[@huynhthach1813]

This is exactly what I'm looking for! thanks!

[@JohnKnorr]

Great tutorial -- how do you protect the sheet, while still allowing someone to use the search?

[@BlacKnight9]

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

[@rajwirmani4758]

Really helpful topic. Thanks

[@laraoluwasusi]

This is so great & helpful! Thank you Kevin!

[@Xe54official]

Kevin! You’re my hero

[@nateshiyer4552]

Love the way you teach you are very good

[@imwatchingyourchannel2686]

Thank You So Much Sir, This Is Very Helpful For My Work 😊😊😊😊

[@AstroAnalytics]

Thanks and very well explained👏👏👏

[@hagarshaheen4062]

May I ask if there is a way to add the “filter” function as I couldn’t find it, please? Thanks in advance 🙏

[@okfiremuseum]

did you ever figure out how to add the "filter" button? Mine is missing as well.

[@anthonycambrit]

Excellent.....Love from India🥰🥰

[@iamcharith]

Hi Kev, thanks for the video. Could you please make a video about advanced conditional formatting?

[@onexl001]

Thanks for sharing this valuable information..

[@KevinStratvert]

Glad it was helpful!

[@richardnorman2313]

Is there a way to keep a hyperlink active when it’s filtering the information? I found this tutorial extremely helpful!

[@siddhantyadav5685]

KEVIN! KEVIN! KEVIN! MAKE VIDEOS ON HTML AND CSS

[@S.Psychology]

This is really awesome.... More such videos please

[@edircoronado9334]

With this search function are you able to edit the retrieved information?

[@hr.sanders]

thank you very much. it was extremely helpful.

[@DanBrill]

Fantastic. This is going to make for a very easy way for my users to search a table. Thanks!

[@kaylak08]

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?

[@continuum3619]

Can you please, tell me about text expander with clipboard tools and also if there's is privacy concern. I am looking to pharseExpress but am not sure about privacy. Should I be concerned and can my password be compromised.

[@wangzig9800]

Thanks for your help in advance. I have no filter function in my MS office 2021 Pro Plus!. what should I do?

[@corneliuspretorius3790]

Hi Kevin. Can the target array be the full workbook, incl certain or all worksheets? One or Multiple Search box es but on one worksheet - on the Dashboard. Much appreciated. Neels

[@VERTICALcube]

Hi Kevin, first of all I wanna thank you for sharing such immense information with all of us. I just want to know if you have similar formulas that excel previous versions can do with all of these formulas, like excel 2010 or 2016? We still have these versions with our dozens of employees from afar. And this is really useful if they can have excel with similar formula in their older versions of excel.

[@DaineAdamsen]

Is it possible to have it search mutiple sheets instead of just the one?

[@lavdonbela2479]

When did you link the input of the searh box with the filter formula ?

[@xenderx7118]

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.

[@devarshnayyar3910]

Great video with a useful trick. Thanks

[@rubenpedersen5483]

Hi Kevin! Tanks for great teaching! I have only one question; I'm self taught when it comes to Excel. When i follow your recipe, all data in the table will be displayed in the searc-area if the serch-box remains empty. In my case i follow your tutorials and my table is a crew list. Where search result should come up seems correct. But if the searc box i empty, the entire table i displayed here. Is there any way to avoid this? Once again, thank you for good teaching!

[@asim4me]

Hi, i have also same question

[@AdutBand1]

Does this function work with Numbers?

[@charlesrodriguez2176]

Kevin, thank you for this video!

[@aquaicecold]

I LEARN SO MANY...THANKS SO MUCH..

[@nilamani_deka]

Wonderful Sir .....

[@daXcel7448]

Thanks for the video. Could you kindly tell me the name of the mic you use to record the videos?

[@julianaramburo2023]

Hi, thanks for this video. It's awesome. I tried using the dynamic search, and I did exactly what you did, but for some reason the cursor and the text don'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 dynamically, but I cannot see what I'm typing and it's really annoying. Can you help? thanks so much

[@wonderland9690]

Incredibly useful video, thanks a lot!

[@AnthonyZaragoza-u1r]

Sir Kevin. Is there a way to use Filter function on Office 2019?

[@BigJim2323]

Kevin....love your videos. Can you please show a video about changing logo size to fit email signature or webpage?

[@CHHENGVEAYO]

Thanks for your video and I have a question, What can I do if my excel Fx dos not show filter?

[@mikeellis7828]

I wonder if there is any way to display the table row # in the search results

[@KevinStratvert]

You can add the row number as a column and return it just like everything else 👍

[@Deals-reviews-DIY]

Love your video. Thank you very much. Please explain how to to add embedded link in search box results. All is working well but the cell that have embedded link, not included in the search box.

[@YaelEylatTanaka]

Who in their right mind decided to create such a mind-boggling system?!!! This is INSANE.

[@nimrahabish4395]

Very useful nice content

[@HubertKirchgaessner]

This is awesome! Thanks, Kevin!

[@fmpereira1]

Hey Kevin! Thank you very much for that! I always dreamed including a full functional search box in my Excell spreadsheets. But let me ask you: how to filter the results directly from the data resources other than reflecting in another mirrored column?

[@TechTeacherTT]

If I understand your question correctly. You would like to filter the data from the beginning rather than copying a column to display filtered data. I think that you could solve this by using the built in power query of excel. This allows you to directly the filter the data from the source. Hopefully this helps!!

[@dandro18048]

@@TechTeacherTT I think the question is not asking that. I think he is asking how to create a search box that will display the results of the search directly in the first table itself (the one containing all the data). I would suggest following the same steps as shown in the video and just hiding the table with the data or moving it to another sheet and hiding that sheet (or restricting access as necessary).

[@rodrickkonyango9616]

Great video Kevin! please make a video on how to search two or more tables but on different worksheets

[@jessaleneetcobanez6818]

Thank you for this! Can you have multiple search box that can filter 2 columns?

[@aureliocam6308]

Kevin you da man !!!

[@j.r.releford6862]

Hi Kevin! Thanks for this really great tutorial. Overall I’ve been able to apply all the instructions however for some reason my table highlights yellow when no text is in the search box. Are you able to help me understand why this might be?

[@prabhathborkar7953]

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.

[@BE4FIT]

Hi, can I find hyperlinks in the search box?

[@Hayatejerry]

great content sir,keep doing tutorial like this