Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-03-2016, 01:20 PM
afoster afoster is offline formula to isolate............ Windows XP formula to isolate............ Office 2013
Novice
formula to isolate............
 
Join Date: Jun 2016
Posts: 2
afoster is on a distinguished road
Default formula to isolate............

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
Reply With Quote
 



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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:16 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft