Long list of words to find with Filter

E

englishtwit

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
 
E

englishtwit

This is an excellent answer - however, the list that I have could hav
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 yo
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 technica
solution I can use is Excel.

Hear's hoping!

E
 
Top