Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Long list of words to find with Filter
Hi peeps I have a long list... School College Borough County City Council CC (County Council) Care Nursing Home Primary Trust PCT (Primary Care Trust) Hospital Commission etc etc of words that I want to filter on in a list... I tried creating a macro, but it only allows two criteria... Any ideas as to how I might do this in one operation? Also, to easily add words to this list! Yours hopefully ET -- englishtwit ------------------------------------------------------------------------ englishtwit's Profile: http://www.excelforum.com/member.php...fo&userid=5464 View this thread: http://www.excelforum.com/showthread...hreadid=388276 |
#2
|
|||
|
|||
You can use an Advance Filter to extract the data. There are
instructions in Excel's Help, and he http://www.contextures.com/xladvfilter01.html englishtwit wrote: I have a long list... School College <snip etc etc of words that I want to filter on in a list... I tried creating a macro, but it only allows two criteria... Any ideas as to how I might do this in one operation? Also, to easily add words to this list! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
This is an excellent answer - however, the list that I have could have the words details any where in the row. So - column a might contain St Jospehps Pre-school University of St Helen Johns Accountancy Service The solution suggested is great, but will only work if the list you you searching for has the 'criteria' word at the start of the row. I have 50 words (and growing) that I need to find. The only technical solution I can use is Excel. Hear's hoping! ET -- englishtwit ------------------------------------------------------------------------ englishtwit's Profile: http://www.excelforum.com/member.php...fo&userid=5464 View this thread: http://www.excelforum.com/showthread...hreadid=388276 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
cannot find list in excel 2000 | Excel Discussion (Misc queries) | |||
how do i find out what is uncommon in column list A1: A10 and B1:. | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) |