One idea - use autofilter on a helper col
Assuming source data as posted in A2:C2 down
In D2: =IF(AND(TRIM(C2)="VERREV",OR(TRIM(B2)={"S","W"})), "x","")
Copy down all the way. Apply Autofilter on col D, choose: x
to filter/isolate as required.

Success? High-five it here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"b4nature" wrote:
In the sample below I need to be able to isolate students who have a G status
for the VERREV code and an S or W status for all of their other codes. I have
no idea where to begin.
Thanks!

A B C
1 Student Status Code
2 Krystal G VERREV
3 Krystal S LINCBY
4 Krystal S QAWK10
5 Krystal S TAX08S
6 Krystal S W208ST
7 Krystal W TAX08P
8 Krystal W W208PA
9 Margaret T CORREC
10 Margaret S QAWK10
11 Margaret S TAX08S
12 Margaret S VERREV
13 Margaret S W208ST
14 Michael S LINCBY
15 Michael S QAWK10
16 Michael G VERREV
17 Michael W TAX08S
18 Michael W W208ST