🏫 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: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
When you said "Spoiler Alert" that's the moment you nailed the pin down. You've totally upped your game with the thumbnails, the audio the video it's just so much improvement from the past year! Love the way you listen to small people's advice! I would just be grateful for a cookie though!
Finally, I found video which really help me. I stuck in spills error many days. this is very clear, very useful for my over hundred lists of raw materials for kitchen. Thank you so much Kevin.
Thanks for this video Kevin, I have followed the steps from the spreadsheet you have given. Now I learnt how to insert Searchable Drop-Down List in MS-Excel.
I've been lately seeing that you are working on your cookies! It was first back then an example and now it's real! We asked you delivered! And yes, when I will order a cookie as soon as possible, just can't wait to taste!!!
Love it! ❤️ Hopefully Microsoft is able implement the searchable drop-down on desktop app soon so we no longer need to do this workaround and so it would be easier as well for those who are not Office 365 subscribers.
Hi kevin , instead of going for a transpose and hiding the columns of the validated list, I recommend you could use the function "cell('contents")" as the search criteria for the search function initially (instead of "A6" in you formula) so that you can use the same formula on all rows and search gets modified based on what you type in the cell.
@@jasirmanakkamburath9685 instead of referring to A6, you can type "=cells(contents )"...so change made anywhere will be reflected in the formula, thus we can do away with transpose to hide columns that does not show our required data...
You don’t even know how much you helped me, I was going nuts because I had to apply the formula on many cells… This was really really helpful, thank you very much. 😭❤️
@@KevinStratvert Kevin, I love your videos about Drop Down Lists...Do you know of a way to include an "alias", "AKA", or "keyword" into the search? For instance, what if you wanted people to find Vegan cookies or Peanut free cookies but didn't want to include those words in the cookie name? THANK YOU!
Thanks for the trick, Kevin, very useful. I actually didn't know that excel online was able to filter automatically. I use to set another trick though, combining OFFSET, MATCH and COUNTIF. Basically, if the table of cookies is named "cookies", and you are typing in B6, then the formula of the dropdown list can be set as : =OFFSET(cookies,MATCH(B6&"*",cookies,0)-1,,COUNTIF(cookies,B6&"*"))
I tried renaming the table, but it wouldn't accept your formula because that name is already in use. I then tried to change your formula above to match the correct table name 'cookiestypes' (yes, that's exactly how it's spelled). Still couldn't get it to work. I then tried to use your formula in the Data Validation - List dialog box. Still no luck. Would LOVE clarification because I couldn't make sense of the TRANSPOSE option and feel like your formula would be simpler. Thanks in advance!
What do you think about a giveaway of cookies? 😂😂😂 We should create the best cookie order drop down lists, and Kevin will decide which one is the best 😂😂😂 Best Excel tutorial! Thank you so much for help💪
For sure I'd buy cookies from Kevin Cookie Company! and Thank you so much for this video. I'm creating a form to help my husband with his job. It will be his Christmas gift. Happy Life Kevin!
Hi, Kevin. This is Samiullah Ehsan from Pakistan. Your videos are ever helpful. Your How-To videos have helped me with my Excel use. I am currently taking a Data analysis course and lately completed a Business Analysis course. I would humbly request you to make a playlist "Business Analysis and Excel", wherein you teach How-To use Excel as a Business Analyst to quantify the business as a number(defining and evaluating business as a metric, as a KPI) and How-To analyse these metrics as business measurements over time (understanding root cause of changes in metrics, building and analysing dashboards and reports, using planar line chart in excel for analytics, predictive analysis, statistical analysis, regression etc) and other important uses of excel that a business analyst should know. Kindly, do make it. Again, it is a humble plea, kindly, do consider it.
Superb! Thanks for addressing the desktop solution. I do a lot of work for my Volunteer Fire Dept., but we are rural with spotty internet (so online solutions seldom work for us). This will help me develop some Excel data entry forms for inventory, equipment checks, vehicle maintenance, and incident reporting.
WOW Sir!!!! I am glad to know Someone like you who uses their talent from working at Microsoft to help others master their work!!! This will really help in attendance lists and more. Keep up your hard work. You are the best!!🔥🔥🔥👍👍👍👍🙏🙏🙏🔥🔥🔥🔥🔥
Hi, Great Video. At 16:59 you type in "butter" and are able to immediately click on the dropdown. I am finding I need to press enter before the search is activated., which is a bit of a pain as I then need to click back into the cell to activate the dropdown. Any idea why?
Thank you. Document finally working. I do have one question though, what do you do to add a row to the data validation drop down list and have the table source (with formulas) update?
Hi, coming back to Excel after 20 years...your videos have been great! I'm now using a form to enter data. I got the drop down menus to work fine on the spreadsheet (thankyou), but I can't get them onto the form. Can you help?
Hi Kevin, Nice job, I Like it!! First I'm on Win 10 , Microsoft 365, and my system is fully updated, with I7 Processor, and high-end graphics card, and 16GB!. power user from corporate with a background. I think you have an error in both examples I have rechecked all code 4 times -no errors! In both examples as long as you advance down with your searches, ALL is WELL! But if you try to back up the list with a search it falls, by only finding 1 or staying lock a the last search input. Might waant to take a look? Thanks, keep up the great work!! Rod
Hey Kevin, I have a question on searchable drop down list. Does it work for different languages other than English? Cuz when I type words in the list, obviously different language other than English, the list of words that are in the list does not show up to pick. what do I do?
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
🏫 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: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
By far, the best example of a searchable drop down! Everyone I have seen so far does just one cell, THIS is what most probably needed! Thank you
When you said "Spoiler Alert" that's the moment you nailed the pin down. You've totally upped your game with the thumbnails, the audio the video it's just so much improvement from the past year! Love the way you listen to small people's advice! I would just be grateful for a cookie though!
I love the way you kick start your videos with “To-day”… 😄 Thanks so much for all these useful lessons!!🙏🏻
Finally, I found video which really help me. I stuck in spills error many days. this is very clear, very useful for my over hundred lists of raw materials for kitchen. Thank you so much Kevin.
Thanks for this video Kevin, I have followed the steps from the spreadsheet you have given. Now I learnt how to insert Searchable Drop-Down List in MS-Excel.
I just spent 2 hours on this video...and...well....it solved my problem! Thank you!
I've been searching for a very simple follow along tutorial for over an hour now... Glad I found your video.. Thank you for making this so simple 👏👏👏
I've been lately seeing that you are working on your cookies! It was first back then an example and now it's real! We asked you delivered! And yes, when I will order a cookie as soon as possible, just can't wait to taste!!!
Love it! ❤️ Hopefully Microsoft is able implement the searchable drop-down on desktop app soon so we no longer need to do this workaround and so it would be easier as well for those who are not Office 365 subscribers.
I wouldn't hold your breath.
@@charlesxix lp
Seems like I'm being punished with this long winded complicated way just because I pay for the subscription????? Makes no sense!
Kevin saved my day, this is the best video I found for a searchable drop down list
Hi kevin , instead of going for a transpose and hiding the columns of the validated list, I recommend you could use the function "cell('contents")" as the search criteria for the search function initially (instead of "A6" in you formula) so that you can use the same formula on all rows and search gets modified based on what you type in the cell.
hi sunil, can you please explain how can i apply cell function instead of transpose??
@@jasirmanakkamburath9685 instead of referring to A6, you can type "=cells(contents )"...so change made anywhere will be reflected in the formula, thus we can do away with transpose to hide columns that does not show our required data...
@@chandrusunil Clarification please? Perhaps provide the complete suggested formula and where it would be entered. Thanks in advance!
@@Sparqcorporatetrainingin the search function of the "isnumber" column you can change the cell reference from A6 to =cell(contents)
Thank you. I already knew all of it except for the transpose. That is amazing. I just didn't know about transpose. Thanks again.
Been searching for the multiple rows with sreachble dropdows for over 3 montnhs now. This is great! Than you so much
You don’t even know how much you helped me, I was going nuts because I had to apply the formula on many cells… This was really really helpful, thank you very much. 😭❤️
I’ve been looking for something like this for a while now. Thank you!
thank you. I've been searching for this for a long time. great job presenting the info in a simple and understandable format.
I have a Excel class now and I needed this video thanks for uploading this video Kevin!
Kevin should now give us some cookies, he is not just a RUclipsr he is a cook in Seattle. 🌎
Looking into starting up some cookie sales for the Kevin Cookie Company with a commercial kitchen. Stay tuned! 🤣
@@KevinStratvert Hey man you should make a top of best phone emulators for pc ,also great videos
@@KevinStratvert Kevin, I love your videos about Drop Down Lists...Do you know of a way to include an "alias", "AKA", or "keyword" into the search? For instance, what if you wanted people to find Vegan cookies or Peanut free cookies but didn't want to include those words in the cookie name? THANK YOU!
best excel teacher in the world
As always, brilliantly delivered Kevin!
Thank you Charles!
You are amazing, I watch all your videos. They are useful☺
@Kevin Stratvert You are a very good teacher 👍
great video kevin..the best drop down method by far..❤💥💯
Thank you so much!!!! You have saved me from a massive headache of a problem I was having.
Thanks for the trick, Kevin, very useful. I actually didn't know that excel online was able to filter automatically.
I use to set another trick though, combining OFFSET, MATCH and COUNTIF.
Basically, if the table of cookies is named "cookies", and you are typing in B6, then the formula of the dropdown list can be set as :
=OFFSET(cookies,MATCH(B6&"*",cookies,0)-1,,COUNTIF(cookies,B6&"*"))
I tried renaming the table, but it wouldn't accept your formula because that name is already in use. I then tried to change your formula above to match the correct table name 'cookiestypes' (yes, that's exactly how it's spelled). Still couldn't get it to work. I then tried to use your formula in the Data Validation - List dialog box. Still no luck. Would LOVE clarification because I couldn't make sense of the TRANSPOSE option and feel like your formula would be simpler. Thanks in advance!
Hii bro,Love from india❤
Loving the recent excel videos!
You are my best online teacher, Kevin Your videos help me a lot
Thank you!
David you are a blessing
Great video. The only drawback with the solution is, that you can't type while pull-down is open, and see the irrelevant options disappear 😁
What do you think about a giveaway of cookies? 😂😂😂
We should create the best cookie order drop down lists, and Kevin will decide which one is the best 😂😂😂
Best Excel tutorial! Thank you so much for help💪
I love this! I think I love you! You explained sth so easily in one video that I've been trying to find out in five separate videos.
thank you kevin for this video i was looking for this thing on how to create excel searchable drop down list
it has really helped me
thanks kevin
I learned a lot here. Thank you Kevin.
Superb, I was just trying different options and you just solved with Transpose! --- Just wonderful.
That helped me a lot to create some more comprehensive things in Excel. Thank you!
You are the best in explaining Excel👍👍
Congrats on 835 K subsribers Kevin🎉
1 million soon!
Superb, You help solve my problem especially with "transpose" fiture for multiple rows. Thanks!
Awesome techniques you are teaching us.. appreciate your efforts.. thank you.. 🙏
I've learnt 3 more formulas and combine in 1, thank you
For sure I'd buy cookies from Kevin Cookie Company! and Thank you so much for this video. I'm creating a form to help my husband with his job. It will be his Christmas gift. Happy Life Kevin!
Thank you. Appreciate your tireless effort.
Another fantastic training video! TY!!👍
You are the best bro, thank you so much❤❤may you live a happy life😊
+2 points for you Kevin. Watched similar video and lacks web solution and multiple row solution which I needed. Thank you very much!
Excellent video, thank you Kevin
Hi, Kevin. This is Samiullah Ehsan from Pakistan.
Your videos are ever helpful.
Your How-To videos have helped me with my Excel use. I am currently taking a Data analysis course and lately completed a Business Analysis course.
I would humbly request you to make a playlist "Business Analysis and Excel", wherein you teach How-To use Excel as a Business Analyst to quantify the business as a number(defining and evaluating business as a metric, as a KPI) and How-To analyse these metrics as business measurements over time (understanding root cause of changes in metrics, building and analysing dashboards and reports, using planar line chart in excel for analytics, predictive analysis, statistical analysis, regression etc) and other important uses of excel that a business analyst should know.
Kindly, do make it.
Again, it is a humble plea, kindly, do consider it.
Great video as always Kevin! Waiting for a Windows 365 video :)
Coming tomorrow Harry! Thanks for the suggestion!
Very asome! Saved me a lot of time and pain!!!!!!!!!!!
amazing demo, thanks so much for sharing!
your videos are awesome❤❤👍
you nailed it thankyou love from india
this has been very helpful! thank you
Thanks for this Kevin. It's really hard to manage massive data in excel and I need to simplify the monitoring before I get out from the university.
Thank you so much Kevin!!
Amazing man , loved it
Kevin, it's a bit complex for a beginner, but very innovative, advanced and practical approach it is I should say. Thanks!
Kevin, you rock!
Thanks for helping me, Kevin
Hi Kevin I'm using excel 2019 which doesn't have the filter function, do you have a solution to use alternative function to achieve the same result?
As always....Amazing
Very useful and informative 🌼🌼🌼🌼🌼
the cookie jokes were amazing!
Great explanation, step by step logic 👍
Superb! Thanks for addressing the desktop solution.
I do a lot of work for my Volunteer Fire Dept., but we are rural with spotty internet (so online solutions seldom work for us). This will help me develop some Excel data entry forms for inventory, equipment checks, vehicle maintenance, and incident reporting.
Thanks a ton! Your video is great!*****
That was awesome. Thank you
Thank you so much! This was great and you made it look so easy!
huge help, thanks man
This was great! Thanks!
Very helpful. Thank you very much.
WOW Sir!!!! I am glad to know Someone like you who uses their talent from working at Microsoft to help others master their work!!! This will really help in attendance lists and more. Keep up your hard work. You are the best!!🔥🔥🔥👍👍👍👍🙏🙏🙏🔥🔥🔥🔥🔥
Yes 👍🏼
Thank you so much! This was awesome 👏🏻
Great help mate, thank you!
Awesome! Thank you!
Hi Everyone Kevin here love the introduction Kevin
Thank you so much!!
Thank you so much Sir
thanks the only thing i don't like on data validation is the dropdown list, the text i gets pretty small and then you have to zoom in.
Hi, Great Video. At 16:59 you type in "butter" and are able to immediately click on the dropdown. I am finding I need to press enter before the search is activated., which is a bit of a pain as I then need to click back into the cell to activate the dropdown. Any idea why?
I have the same issue. Would love to hear if you find any solution to this?
Definitely shall order Cookies from the Kevin Cookie Company!
Nice, (Genius Hovindu) those cookies sound good LOL, Kevin I love your videos.
Thank you. Document finally working. I do have one question though, what do you do to add a row to the data validation drop down list and have the table source (with formulas) update?
Cool tricks!
Love the video and how you simplify things
Very very good 😊
Brilliant ❤
Thank you 😊 Kevin you're my Official "goto" for answers on Excel. Van you please make a video tutorial on Microsoft SQLite please.
Gud afternoon professor. Wow i m first . Front seat🧐
Many thanks, Meantime I was unable to see Filter functions with my excel
Well done :) Thank you.
do you have an idea - why I cannot find numbers like: 2664 asdfasdf?
Hi, coming back to Excel after 20 years...your videos have been great! I'm now using a form to enter data. I got the drop down menus to work fine on the spreadsheet (thankyou), but I can't get them onto the form. Can you help?
Thanks Kevin! great video! How can I apply this searchable dropdown to multiple rows? Could you make a video about it?
Hi Kevin, Nice job, I Like it!! First I'm on Win 10 , Microsoft 365, and my system is fully updated, with I7 Processor, and high-end graphics card, and 16GB!. power user from corporate with a background. I think you have an error in both examples I have rechecked all code 4 times -no errors! In both examples as long as you advance down with your searches, ALL is WELL! But if you try to back up the list with a search it falls, by only finding 1 or staying lock a the last search input. Might waant to take a look? Thanks, keep up the great work!! Rod
This is good, thank you so much for sharing =)
It helped me, thanks
Hey Kevin, I have a question on searchable drop down list. Does it work for different languages other than English? Cuz when I type words in the list, obviously different language other than English, the list of words that are in the list does not show up to pick. what do I do?
Hi Kevin, thanks for videos, Do we have solution for those filter option is not available?
where the solution i cant find filter fx