LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
complex formula? Ronny Excel Discussion (Misc queries) 1 October 7th 07 03:02 PM
Complex Formula Watty30 Excel Discussion (Misc queries) 1 June 20th 07 09:46 PM
Complex Formula marwildfw Excel Worksheet Functions 6 May 29th 07 08:34 PM
Can someone help with this complex formula? My2Boyz9802 Excel Worksheet Functions 4 April 21st 06 05:12 PM
Complex formula Marc Excel Discussion (Misc queries) 8 October 20th 05 02:37 AM


All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"