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