Excel Searchable Drop Down List - No VBA and No Formulas! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
nounix
This looks VERY complicated to bother with!! :( :( Isn't there a simple search function in Excel (2019 for mac) where you type in a search box your search letters/words) and the sheet narrows down the columns that contain your search query? So as you type in more letters in this search box, the resulting columns get less and less in your sheet? You now, simple, user friendly, stuff! ;)
reply
This looks VERY complicated to bother with!! :( :( Isn't there a simple search function in Excel (2019 for mac) where you type in a search box your search letters/words) and the sheet narrows down the columns that contain your search query? So as you type in more letters in this search box, the resulting columns get less and less in your sheet? You now, simple, user friendly, stuff! ;)
reply
Iv-n
Super video Mynda! I like your Pivot Table with this special useful. Great graphic and the table with (Gross Profit, MAX, MIN, AVERAGE) that's in a superior level of the pivot table. I see a limitation in the not being able to use Slicers, but anyway I am fascinated by your creation. It is an excellent practical application of the Filter field in Pivot Tables. Thank you very much.
reply
Super video Mynda! I like your Pivot Table with this special useful. Great graphic and the table with (Gross Profit, MAX, MIN, AVERAGE) that's in a superior level of the pivot table. I see a limitation in the not being able to use Slicers, but anyway I am fascinated by your creation. It is an excellent practical application of the Filter field in Pivot Tables. Thank you very much.
reply
Kuku
What if you need to have a dynamic, searchable drop down list from another workbook?
Use case: Lets say I have a list of all my products and want to write an invoice, and you have about 2000 products. How would you make a searchable drop down list that changes as you add or modify products? The data validation list is in another workbook.
reply
What if you need to have a dynamic, searchable drop down list from another workbook?
Use case: Lets say I have a list of all my products and want to write an invoice, and you have about 2000 products. How would you make a searchable drop down list that changes as you add or modify products? The data validation list is in another workbook.
reply
Gary
Mynda, this is awesome. Can't tell you how long I tried data validation filters, combo boxes, etc. and this is so much easier.
Is there any way to fix the width of the dropdown box? My data strings are long. I noticed you had to drag the corner of the box to make it wider. Thanks
reply
Mynda, this is awesome. Can't tell you how long I tried data validation filters, combo boxes, etc. and this is so much easier.
Is there any way to fix the width of the dropdown box? My data strings are long. I noticed you had to drag the corner of the box to make it wider. Thanks
reply
Jens
Mynda, you can't imagine, how long I was looking for exactly this function. So easy as useful. Formatted PivotTables seem to be a powerful hidden function to get more out of Excel. I really appreciate your videos. Big thumbs up smashed.
reply
Mynda, you can't imagine, how long I was looking for exactly this function. So easy as useful. Formatted PivotTables seem to be a powerful hidden function to get more out of Excel. I really appreciate your videos. Big thumbs up smashed.
reply
Nguyen
Wonderful technique! Thank you so much
Pls teach me how to do multiple searchable drop down list.
Pivot dont allow multiple searchable drop down list with same data source -
reply
Wonderful technique! Thank you so much
Pls teach me how to do multiple searchable drop down list.
Pivot dont allow multiple searchable drop down list with same data source -
reply
R.
The shortcoming of using Pivot table is that if your data is updated, you have to refresh the pivot table first before doing the search. If you use formulas, no refreshing is needed.
reply
The shortcoming of using Pivot table is that if your data is updated, you have to refresh the pivot table first before doing the search. If you use formulas, no refreshing is needed.
reply
itech
Dear Mam, what is the code for -waiting till webpage completely loads in chrome using excel vba- as it is -ie.readystate = readystate_complete- in internet explorer
reply
Dear Mam, what is the code for -waiting till webpage completely loads in chrome using excel vba- as it is -ie.readystate = readystate_complete- in internet explorer
reply
Jessica
Where is the facepalm emoji when we need it! This is something so simple that most of us have completely overlooked it until now. Thanks for setting us straight!
reply
Where is the facepalm emoji when we need it! This is something so simple that most of us have completely overlooked it until now. Thanks for setting us straight!
reply
Ian
Gosh that's brilliant! I'd never have thought of using pivot tables (of which I'm not particularly a fan) in that way! Many thanks - it's given me some ideas --
reply
Gosh that's brilliant! I'd never have thought of using pivot tables (of which I'm not particularly a fan) in that way! Many thanks - it's given me some ideas --
reply
Add a review, comment
Other channel videos
