Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for Text in Excel
I am creating a list of part numbers of which some will be similar (different
variants of products) and I want to create a user search function eg a search box that the users could enter the first few letters followed by a wild card eg EV* and then the products starting with that prefix would be found. I know you can use the Find function under Edit, but I was hoping for a more user friendly tool. Any ideas. Regards Duncan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for Text in Excel
Data|Filter|Autofilter
And then custom filter: Begins with EV (or equals EV*) Maybe... Duncan, UK wrote: I am creating a list of part numbers of which some will be similar (different variants of products) and I want to create a user search function eg a search box that the users could enter the first few letters followed by a wild card eg EV* and then the products starting with that prefix would be found. I know you can use the Find function under Edit, but I was hoping for a more user friendly tool. Any ideas. Regards Duncan -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for Text in Excel
Okay...what Duncan, UK is trying to do is essentially what I am trying to do,
except that I want to make it EVEN EASIER for the user, so that he/she can enter the text into a Text Box Form and press Enter, and the data will be AutoFiltered by the text string that they have just entered. How can I do that? Thanks! "Dave Peterson" wrote: Data|Filter|Autofilter And then custom filter: Begins with EV (or equals EV*) Maybe... Duncan, UK wrote: I am creating a list of part numbers of which some will be similar (different variants of products) and I want to create a user search function eg a search box that the users could enter the first few letters followed by a wild card eg EV* and then the products starting with that prefix would be found. I know you can use the Find function under Edit, but I was hoping for a more user friendly tool. Any ideas. Regards Duncan -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for Text in Excel
Thanks, that is another way, but I was hoping for a more user friendly way.
eg like a text box on the sheet that performed the same thing. I know how to find use 'Edit & Find' and 'Filters', but the users this is aimed at users with limited experience and knowledge. Thanks "Dave Peterson" wrote: Data|Filter|Autofilter And then custom filter: Begins with EV (or equals EV*) Maybe... Duncan, UK wrote: I am creating a list of part numbers of which some will be similar (different variants of products) and I want to create a user search function eg a search box that the users could enter the first few letters followed by a wild card eg EV* and then the products starting with that prefix would be found. I know you can use the Find function under Edit, but I was hoping for a more user friendly tool. Any ideas. Regards Duncan -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for Text in Excel
You can build a textbox (or just a dedicated cell) then show the find dialog.
or maybe... Even use an addin that's very nice-- Jan Karel Pieterse's FlexFind: http://www.oaltd.co.uk/MVP/ But I don't see how anything could be much simpler than Ctrl-f (edit|Find). Duncan, UK wrote: Thanks, that is another way, but I was hoping for a more user friendly way. eg like a text box on the sheet that performed the same thing. I know how to find use 'Edit & Find' and 'Filters', but the users this is aimed at users with limited experience and knowledge. Thanks "Dave Peterson" wrote: Data|Filter|Autofilter And then custom filter: Begins with EV (or equals EV*) Maybe... Duncan, UK wrote: I am creating a list of part numbers of which some will be similar (different variants of products) and I want to create a user search function eg a search box that the users could enter the first few letters followed by a wild card eg EV* and then the products starting with that prefix would be found. I know you can use the Find function under Edit, but I was hoping for a more user friendly tool. Any ideas. Regards Duncan -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for Text in Excel
Thanks. I will try that. I know it is easy, but you haven't met the people
that this is intended for....I shouldn't be rude, but honestly they have very little idea about PCs, let alone Excel. Cheers "Dave Peterson" wrote: You can build a textbox (or just a dedicated cell) then show the find dialog. or maybe... Even use an addin that's very nice-- Jan Karel Pieterse's FlexFind: http://www.oaltd.co.uk/MVP/ But I don't see how anything could be much simpler than Ctrl-f (edit|Find). Duncan, UK wrote: Thanks, that is another way, but I was hoping for a more user friendly way. eg like a text box on the sheet that performed the same thing. I know how to find use 'Edit & Find' and 'Filters', but the users this is aimed at users with limited experience and knowledge. Thanks "Dave Peterson" wrote: Data|Filter|Autofilter And then custom filter: Begins with EV (or equals EV*) Maybe... Duncan, UK wrote: I am creating a list of part numbers of which some will be similar (different variants of products) and I want to create a user search function eg a search box that the users could enter the first few letters followed by a wild card eg EV* and then the products starting with that prefix would be found. I know you can use the Find function under Edit, but I was hoping for a more user friendly tool. Any ideas. Regards Duncan -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for Text in Excel
I've found that if they never get a chance to learn, then they'll never learn.
And by just showing them how to use edit|Find (or ctrl-f), think of all the other applications that are now a bit easier for them. Duncan, UK wrote: Thanks. I will try that. I know it is easy, but you haven't met the people that this is intended for....I shouldn't be rude, but honestly they have very little idea about PCs, let alone Excel. Cheers "Dave Peterson" wrote: You can build a textbox (or just a dedicated cell) then show the find dialog. or maybe... Even use an addin that's very nice-- Jan Karel Pieterse's FlexFind: http://www.oaltd.co.uk/MVP/ But I don't see how anything could be much simpler than Ctrl-f (edit|Find). Duncan, UK wrote: Thanks, that is another way, but I was hoping for a more user friendly way. eg like a text box on the sheet that performed the same thing. I know how to find use 'Edit & Find' and 'Filters', but the users this is aimed at users with limited experience and knowledge. Thanks "Dave Peterson" wrote: Data|Filter|Autofilter And then custom filter: Begins with EV (or equals EV*) Maybe... Duncan, UK wrote: I am creating a list of part numbers of which some will be similar (different variants of products) and I want to create a user search function eg a search box that the users could enter the first few letters followed by a wild card eg EV* and then the products starting with that prefix would be found. I know you can use the Find function under Edit, but I was hoping for a more user friendly tool. Any ideas. Regards Duncan -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
How do I get excel search through a range of numbers e.g. 1.99 - . | Excel Worksheet Functions | |||
How do I search for an asterisk in an Excel file--it thinks the a. | Excel Discussion (Misc queries) | |||
Excel - Formula Query: Search for and Return Value | Excel Worksheet Functions |