View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
b4nature b4nature is offline
external usenet poster
 
Posts: 4
Default need complex if formula (I think)

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