formula to isolate............

afoster · #1 06-03-2016, 01:20 PM

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

Similar Threads
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
Formula Help	ashreporter	Excel	3	04-01-2015 10:40 PM
IF + AND formula help	david_89_	Excel	4	06-11-2014 11:07 AM
formula help	rich_cirillo	Excel	3	09-26-2012 11:41 PM
PMT Formula	OneOleGuy	Excel	4	03-05-2011 09:54 AM