The attached spreadsheet is a very slimmed down example of what I am working with.

What I am hoping to achieve is to be able to filter the column that expresses subjects of interest (populated by a userform listbox) into certain general areas.

So someone might be really interested in just Business. Whereas another might be torn between English and Management. I want to be able to filter by all the options in 'Business Ranges' in order to find any student who has expressed an interest in one or more of those courses. Is this even possible, or just a pipe dream?

I tried a couple of versions of autofilter either with an array or multiple xlOr criteria (when I subsequently found out that you can only do 2 criteria). I was hoping that maybe I could use named ranges for items to search for - but again, to no avail!

Any help gratefully received.

multicriteria filter test.xls