Thanks! That's a really good start, and I think I see where you're going.
There are over 7,000 rows of data that I need to sort through, though, and
I'm thinking that in that formula, each the A#'s and B#'s need to have the #
of each individual row (if that makes sense). Am I correct in this
assumption? And if so, is there any easier way to enter this formula without
having to change each formula for 7,000 rows?

Thanks again!
--
LEP


"Bob Phillips" wrote:

In a spare column add the formula

=AND(OR(A2=2,A2=3,A2=4,A2=6),OR(LEFT(B2,1)="S",LEF T(B2,1)="L",LEFT(B2,1)="C"),C2<"")

and filter that column for TRUE

--
__________________________________
HTH

Bob

"LauraP" wrote in message
...
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