How to Create Searchable Drop Down List in Excel - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
INIOBONG
Thanks Bro Kevin, your information has change me, thanks once again, seen I have fine you to be the best for me to follow i have downloaded so many application software by your instruction, names, video editing, OBS to record my screen, zoom to use OBS to remove background, and more. Please i will be asking some question, my question today is not about this video is about OBS to record my screen, I have successful downloaded and install OBS which is working as i followed your instruction, But i have a problem when recording and playing, when am recording they display on my monitor screen is okay. But when playing that which i record, i fine out some delay in copy all i have recording, e.g. if i record for five minutes when playing that which is record will play for five minutes, But will display on the play video will be what i cover for A minute or two Minutes, instead of cover what i recording for five minutes, in other word there is a delay in display.
hope to hear from you soon.
reply
Thanks Bro Kevin, your information has change me, thanks once again, seen I have fine you to be the best for me to follow i have downloaded so many application software by your instruction, names, video editing, OBS to record my screen, zoom to use OBS to remove background, and more. Please i will be asking some question, my question today is not about this video is about OBS to record my screen, I have successful downloaded and install OBS which is working as i followed your instruction, But i have a problem when recording and playing, when am recording they display on my monitor screen is okay. But when playing that which i record, i fine out some delay in copy all i have recording, e.g. if i record for five minutes when playing that which is record will play for five minutes, But will display on the play video will be what i cover for A minute or two Minutes, instead of cover what i recording for five minutes, in other word there is a delay in display.
hope to hear from you soon.
reply
Ryan
Fabulous instructions for us novice!!!! I got everything to work, BUT i need the data validation to force them to pick something from the list ONLY. when i turn the error reporting back on in data validation i lose all searching from keyboard typing (error message) If i leave the error alert turned off, i can now start typing to narrow my field. HOWEVER now if they dont fully select the correct item, i'm left with a few key strokes to try to determine what they wanted. CAN ANYONE PLEASE HELP????
reply
Fabulous instructions for us novice!!!! I got everything to work, BUT i need the data validation to force them to pick something from the list ONLY. when i turn the error reporting back on in data validation i lose all searching from keyboard typing (error message) If i leave the error alert turned off, i can now start typing to narrow my field. HOWEVER now if they dont fully select the correct item, i'm left with a few key strokes to try to determine what they wanted. CAN ANYONE PLEASE HELP????
reply
Neeraj
--Kevin Stratvert
Hello Sir, I have a problem in creating searchable drop down list in excel. i have a list want to put in drop down menu, when i press any alphaphet or word in box, list becomes available automatically, like we have when we search in google, what ever we type in google search engine we got suggestions or relevant data. like that i want to create. kindly help.
reply
--Kevin Stratvert
Hello Sir, I have a problem in creating searchable drop down list in excel. i have a list want to put in drop down menu, when i press any alphaphet or word in box, list becomes available automatically, like we have when we search in google, what ever we type in google search engine we got suggestions or relevant data. like that i want to create. kindly help.
reply
Sunil
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.
reply
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.
reply
Hilary
Thank you for all you do. I think this solves half my problem. I need the search to grab 2 pieces of info (the cookie type as well as their quantities). Is there a way to do this? If I knew what this was called I could do a search because chances are you have already got a video to solve my issue. Thanks for any help
reply
Thank you for all you do. I think this solves half my problem. I need the search to grab 2 pieces of info (the cookie type as well as their quantities). Is there a way to do this? If I knew what this was called I could do a search because chances are you have already got a video to solve my issue. Thanks for any help
reply
Fl-vio
Hello Kevin. Thank you very much for the video!-
Do you know how I can i use this formula in a protected sheet? I made a Fill Form in a protected sheet and hid the list in a different sheet, but when I protect the sheet where the dropdown list is people can't search.-
Is there any workaround for this problem?
reply
Hello Kevin. Thank you very much for the video!-
Do you know how I can i use this formula in a protected sheet? I made a Fill Form in a protected sheet and hid the list in a different sheet, but when I protect the sheet where the dropdown list is people can't search.-
Is there any workaround for this problem?
reply
Carlos
Hi Kevin, What about if I'm looking inside a table and I'm inserting a row everything i want to look for a item, I tried doing what you did and the number in the search formula keep changing, so its no giving me the result I'm looking. What do you think I should do Thank you so much!
reply
Hi Kevin, What about if I'm looking inside a table and I'm inserting a row everything i want to look for a item, I tried doing what you did and the number in the search formula keep changing, so its no giving me the result I'm looking. What do you think I should do Thank you so much!
reply
Andrew
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?
reply
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?
reply
Susana
Thank you so much! this is so helpful! you kinda resolve one of my biggest issues in excel. But what if my customers or products are in separates master sheet? which is the only document that is regularly updated.
reply
Thank you so much! this is so helpful! you kinda resolve one of my biggest issues in excel. But what if my customers or products are in separates master sheet? which is the only document that is regularly updated.
reply
Othman
Thanks for great job but i could not find filter function in fx. I could not go on I stopped at the min 9:00 in the clip. Can you help to do something for that. My Excell is 2016 edition. Othman from Libya
reply
Thanks for great job but i could not find filter function in fx. I could not go on I stopped at the min 9:00 in the clip. Can you help to do something for that. My Excell is 2016 edition. Othman from Libya
reply
Add a review, comment
Other channel videos
