I have a sheet of data against which I have assigned categories, sometimes
more than one category to the same piece of data. Is it possible to create a
drop-down list which will then filter this data not as autofilter does but as
a "text contains" filter?

Therefore when people want to look at certain categories, they can select
from the drop-down box and it will show only the data with that particular
category against it (but which may also have other categories as well).

Thanks!