🏫 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: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
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. 🚀
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...
I wonder how much Excel sifus charge in the past for these valuable knowledge and now with UA-cam we're getting it for just a meager cost of data, electricity and time. Thanks Kevin. Super helpful!
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!
Spent hours banging my head against this formula while trying to figure out how to get the multiple columns to work. Thank you so much! Oh, also: this can be done without the fancy ActiveX search box. Useful to know if, like me, you work for an organization that forces the crappy web licence for 365 on you (ActiveX, VBA, and lots of other features being arbitrarily not supported).
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.
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!!!!
"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!
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.
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
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
Well of course I can't choose one cookie because I love every type. But I can choose my favourite UA-camr. It is you. And you are also the first channel that I subscribed to right after I started watching UA-cam videos. I am just excelling in Excel and now I am the smartest. Nah! Just kidding. YOU ARE LITERALLY THE BEST.
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
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.
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
Excellent teaching method. I like how you explain things slowly and with highlights. I have one question.... Are you able to change values in your search results that will remain changed in the original list. For example: Kevin changed his mind and he doesn't want a banana cookie anymore. He wants chocolate chip Your list is very long and you don't want to scroll down to find him. Can you search in the search bar for Kevin, change his cookie to chocolate chip. Will it change to chocolate chip in your original list?
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
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?
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.
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.
Genius! Thank you for this wonderful video. Aside from Leilah Gharani's UA-cam videos yours is equally informative and on point. I definitely subscribe to your channel as well. Keep it up👍🙂
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
🏫 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: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Hi @Kevin Stratvert can you help me creat dis kind of dashboard please
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!
Thanks!
Thanks so much Ed! Much appreciated! 🙏
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. 🚀
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...
I wonder how much Excel sifus charge in the past for these valuable knowledge and now with UA-cam we're getting it for just a meager cost of data, electricity and time. Thanks Kevin. Super helpful!
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!
Spent hours banging my head against this formula while trying to figure out how to get the multiple columns to work. Thank you so much!
Oh, also: this can be done without the fancy ActiveX search box. Useful to know if, like me, you work for an organization that forces the crappy web licence for 365 on you (ActiveX, VBA, and lots of other features being arbitrarily not supported).
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!!!
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.
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.
We cant find filter function
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!!!!
"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!
Kevin is my favourite UA-camr
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.
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
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
Well of course I can't choose one cookie because I love every type.
But I can choose my favourite UA-camr. It is you. And you are also the first channel that I subscribed to right after I started watching UA-cam videos.
I am just excelling in Excel and now I am the smartest.
Nah! Just kidding.
YOU ARE LITERALLY THE BEST.
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
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.
This worked perfectly, thanks a ton!
The way you say "Today" at the start of the video is hilarious btw 😂
Glorious! Thank you, sir. You are a god amongst men.
Kevin! You’re my hero
බොහොම ස්තූතී.... ඔයාගෙ වීඩියෝ එක ගොඩාක් ප්රයෝජනවත් උනා..Thank you very much... your videos are very helpful...
Your videos are so good I come back again after some months!! Thank you!
The sample spreadsheet was so helpful. Love you
Glad it was helpful!
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. :(
Thank you so much! This really helped me build a "Search Engine" on top of a Knowledge Base.
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
1M subs are on the way
Excellent.....Love from India🥰🥰
Thank you Kevin. Very useful.
Really well done. Greetings from Brazil...
That was really good brother to sharing all your video I Irealy enjoy all your video..thnak you for your sharing..
This makes everything so much easier on the excel side for chemical engineering thank you!
Thanks and very well explained👏👏👏
I AM SO LIVING THIS!
Thank you so much, Kevin, for your helpful search box tweak.
Really helpful topic. Thanks
Wow, this is what I want. Thank you very much.
Thanks. Tried this useful tip.
Wow Kevin I never noticed. You are so close to 1M subs!
This is exactly what I'm looking for! thanks!
I never knew this was possible. This is great! This is a top-notch tutorial, loved it!
Great video Kevin.
Best tutorial ever!!!
thank you very much. it was extremely helpful.
Love the way you teach you are very good
Thank You So Much Sir, This Is Very Helpful For My Work 😊😊😊😊
Thanks for sharing this valuable information..
Glad it was helpful!
Great Kevin. Thank you so much for your kindness to everyone.
This is so great & helpful! Thank you Kevin!
Kevin, thank you for this video!
Wonderful Sir .....
Thank a lot Kevin u r brilliant....I really needed this No one can teach better than u... 👏👏👌
Thanks! very cool, just tried it myself
I LEARN SO MANY...THANKS SO MUCH..
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
Kevin thanks a lot for this Tutorial....................BTW can you please make a tutorial on GIMP please🙏
It's on my list! I plan to pull together an in-depth tutorial soon.
Life-saver! Thank you, Kevin.
This is awesome! Thanks, Kevin!
Brilliant thank you Kevin 👌🏽
Thank you Kevin
Fantastic. This is going to make for a very easy way for my users to search a table. Thanks!
Great video Kevin! please make a video on how to search two or more tables but on different worksheets
Kevin you da man !!!
Incredibly useful video, thanks a lot!
Thank You so much
Thanks Kevin, It helps a lot.
Hi Kev, thanks for the video. Could you please make a video about advanced conditional formatting?
Excellent teaching method. I like how you explain things slowly and with highlights. I have one question.... Are you able to change values in your search results that will remain changed in the original list. For example: Kevin changed his mind and he doesn't want a banana cookie anymore. He wants chocolate chip Your list is very long and you don't want to scroll down to find him. Can you search in the search bar for Kevin, change his cookie to chocolate chip. Will it change to chocolate chip in your original list?
Wow fantastic 💞💞💞💞😌
Very interesting tutorial. Thanks 😊
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
Hey there. You perhaps stumbled upon a solution to this?
@@qeazit Ditto!
try 2021
On category instead of clicking most recently used click All
@@danielureta5219FILTER option not available for me. It is showing FILTERXML option which is completely different
you explain clearly thank you sir
This was extremely helpful, thank you!
Very cool man! Great. Thank you.
This is really awesome.... More such videos please
Thank you for everything 👍
Thank you so much for this Kevin. This is SOOO AWESOME!!!
Kevin....love your videos. Can you please show a video about changing logo size to fit email signature or webpage?
0:00 - Hi Kevin. 👋
10:56 - 730th thumbs up from me. 👍 Cheers.
Very useful nice content
Who in their right mind decided to create such a mind-boggling system?!!! This is INSANE.
Thanks so much Kevin, your tutorial is fantastic !
great content sir,keep doing tutorial like this
Great video with a useful trick. Thanks
Thanks for the useful tips. Awesome!
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?
I've been looking for this for so long. Thank you so much Kevin!
Great vedio thanks for sharing.
Love the content!
Is there a way to create a hyperlink with the search results? to enable navigation to another section in another sheet?
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.
Blow my mind! Thanks bro! :)
thank you very much , it's very useful
What a brilliant explaination!! thank you Kevin!! you are doing an amazing job.
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.
Genius! Thank you for this wonderful video. Aside from Leilah Gharani's UA-cam videos yours is equally informative and on point. I definitely subscribe to your channel as well. Keep it up👍🙂
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
Thank you so much!!! This really help me a loooottt!! huhu
Brilliant!
❤❤ very persis thank you kevin