![]() |
#1
|
|||
|
|||
![]()
Hello everyone
I'm attempting to find a formula that will allow me to do the following on a worksheet: Here's what in column A (various usernames) and column B (description containing either STEM School or Smart-Kids School) Column A-----------Column B username----------description cantalician13 ------STEM School ccorbin123---------STEM School ccorbin123---------Smart-Kids School djneedham--------- Smart-Kids School dlynch--------------STEM School epasquini1---------STEM School cbilsky-------------Smart-Kids School cbilsky-------------STEM School djneedham---------STEM School djneedham---------Smart-Kids School epasquini1---------STEM School epasquini1----------Smart-Kids School Is there any way I can create a formula that will give me those accounts that have STEM school ONLY?But here's the hook:It can't have usernames with BOTH Smart-Kids and STEM.It can only produce those usernames that have STEM School.For instance, if it does what I want it to do for the above, the result will produce only 3 usernames that contain only STEM (and not Smart-Kids) and those will be: cantalician13, dlynch, and epasquini1.The others would not work because those usernames have a combination of both Smart-Kids and STEM. Does this make sense and can you please help? Thanks Bert |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
![]() |
ashreporter | Excel | 3 | 04-01-2015 10:40 PM |
![]() |
david_89_ | Excel | 4 | 06-11-2014 11:07 AM |
![]() |
rich_cirillo | Excel | 3 | 09-26-2012 11:41 PM |
![]() |
OneOleGuy | Excel | 4 | 03-05-2011 09:54 AM |