Hello forum!
My boss has asked me to create a rather elaborate filter for a very large
spreadsheet. I need to do a couple of things that seem too complex for the
AutoFilter, and the Advanced Filter keeps giving me an error.

In column A, there are values from 1-11, and I need to filter out all but 2,
3, 4, and 6.

In another column, there are values starting with various letters. I need
to filter out all but those that begin with the letters S, L, and C.

In yet another column, I need to show only those rows that have any entries
at all (which I've figured out how to do with AutoFilter).

Any suggestions? Thanks!
--
LEP