+ Reply to Thread
Results 1 to 9 of 9

Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

  1. #1
    Registered User
    Join Date
    05-01-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

    Hello,

    I am seeking help in writing a formula that will return YES if the Supplier is Xomo AND if the Supplier Bisum job titles do not contain Manager.


    Supplier Job Title Include? (Yes or No)
    Xomo Analyst
    Bisum Manager II
    Bisum Manager III
    Crisin Manager II
    Bisum Manager III
    Bisum Clerk
    Xomo Manager III
    Bisum Manager II
    Bisum Technician
    Bidder Manager I

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,056

    Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

    Try this in C2:

    =IF(OR(A2="Xomo",AND(A2="Bisum",COUNTIF(B2,"*Manager*")=0)),"Yes","No")

    then copy down as required.

    Hope this helps.

    Pete

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,186

    Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

    given what you wrote, this is what I came up with... =IF(OR(A2="xomo analyst",A2="bisum clerk",A2="bisum technician"),"yes","no")
    but it is dependent on the list in post #1 being complete as far as the three different classifications of analyst, clerk and technician.

    EDIT: and I'm assuming the titles are in the same cell while Pete's assumes the titles are split.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,056

    Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

    Hi Sam,

    I have found that when you see a badly-formatted table like the one in Post #1, you can click on Reply With Quote, and then you can usually see more clearly how the original table appeared. You can click on Cancel to abandon that Reply.

    Hope this helps.

    Pete

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,186

    Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

    Oh, cool, always learning something on here. Thanks for the tip Pete.

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,056

    Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

    You're welcome, Sam - thanks for the rep.

    Pete

  7. #7
    Registered User
    Join Date
    05-01-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

    Hi Pete,

    It works perfectly!!! I really appreciate you. Thanks so much!

  8. #8
    Registered User
    Join Date
    05-01-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

    Thanks, Sam!

  9. #9
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,056

    Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

    You're welcome - glad to help.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    You might also like to know that you can show your appreciation directly and thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to evaluate a matrix and return a supplier list
    By The_Snook in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2018, 12:10 PM
  2. [SOLVED] Return cheapest flights (by supplier, price and sort)
    By rayted in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-08-2017, 08:56 AM
  3. [SOLVED] Formula to return supplier names that meet certain criteria
    By The_Snook in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 08-07-2017, 04:52 AM
  4. [SOLVED] Formula that list items from a supplier
    By ricdamiani in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-11-2016, 02:31 AM
  5. I have supplier name in excel.. I need a VBA to the Supplier Web URL
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2013, 01:25 AM
  6. Return the lowest price and supplier
    By Xhelp in forum Excel General
    Replies: 2
    Last Post: 10-25-2011, 04:10 AM
  7. [SOLVED] Select Minimum value and return the name of the supplier
    By Mark McDonough in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-27-2006, 12:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1