Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
complex formula? | Excel Discussion (Misc queries) | |||
Complex Formula | Excel Discussion (Misc queries) | |||
Complex Formula | Excel Worksheet Functions | |||
Can someone help with this complex formula? | Excel Worksheet Functions | |||
Complex formula | Excel Discussion (Misc queries) |