Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
searching within list
Hi all,
this worked for me yesterday, but I don't know why it won't work now. Say I'm searchig in a VERY long list (by the way the list is created from a lookup table) and I want to find names beginning with M - is there a way to type M into the cell rather than scrolling through the whole list? Many thanks again Suzanne :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
searching within list
Hi Suzanne,
did you try autofilter? regards from Brazil Marcelo "sedonovan" escreveu: Hi all, this worked for me yesterday, but I don't know why it won't work now. Say I'm searchig in a VERY long list (by the way the list is created from a lookup table) and I want to find names beginning with M - is there a way to type M into the cell rather than scrolling through the whole list? Many thanks again Suzanne :) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
searching within list
one way: copy data to other sheet and sort it out and see names starting with M second way: press Ctrl+F to open Find window, type M* and click on options Look in select Values and press Find All. But you might need to manually check for names in second method. hope this will help. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=554923 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
searching within list
hmm not quite what i was after
.....isn't there a way of when you're using a drop down list to look for the first letter - to save scolling through them all? "starguy" wrote: one way: copy data to other sheet and sort it out and see names starting with M second way: press Ctrl+F to open Find window, type M* and click on options Look in select Values and press Find All. But you might need to manually check for names in second method. hope this will help. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=554923 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
searching within list
ok, let me put it this way (perhaps it was the way I explained it)
The cell contains a long drop down list To save scrolling to the correct entry I start typing it in the cell and the matching results come back. I did it yesterday! I just don't know how! :) "sedonovan" wrote: hmm not quite what i was after ....isn't there a way of when you're using a drop down list to look for the first letter - to save scolling through them all? "starguy" wrote: one way: copy data to other sheet and sort it out and see names starting with M second way: press Ctrl+F to open Find window, type M* and click on options Look in select Values and press Find All. But you might need to manually check for names in second method. hope this will help. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=554923 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check 2 different list get associated value from a column | Excel Worksheet Functions | |||
Drop-down list Populated by a Subset of a larger list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Searching a list with repeat entries and creating a sum | Excel Discussion (Misc queries) |