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

Hi Bert & Welcome to the Forum,

Why would you return epasquini1 when this name is both STEM School and Smart-Kids School?

Why would the count just not be 2?

cantalician13
dlynch

If 2 is the actual count, does this work for you?

Attached Files

Book1.xlsx (9.6 KB, 20 views)

Hi jeffreybrown and thanks so much for the reply. I apologize for the delay, but I've really been trying to make sense out of it, because it just doesn't seem to be coming together for me. When I opened your doc, I wasn't understanding $F$1:F1 and how it fit in with the formula. I also didn't understand why the 2 usernames (cantalician13 and dlynch) were not on their own row instead of being on F1 and F2. I was thinking all rows that did not apply would be blank and each row that did apply would have that username on that row.

I only listed a few of the items before, but here is the document if you'd like to take a look at it.

Can you tell me what I'm doing wrong?

Thanks again for your help as it's much appreciated.

Attached Files

STEM only - sample1.xlsx (17.4 KB, 13 views)

It is extremely hard for me to help you if you don't help me. Not only is this sheet longer, there is now more in column B than STEM School or Smart-Kids School.

Please add to the workbook your expected results so it is clear what you are looking for in your answer.

Cross posted without links and probably solved

http://www.excelguru.ca/forums/showt...ula-to-isolate

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post