+ Reply to Thread
Results 1 to 5 of 5

Combining two columns if one column satisfies criteria

  1. #1
    Registered User
    Join Date
    02-12-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    6

    Question Combining two columns if one column satisfies criteria

    Hi

    I have two columns I want to create a new column which tells me "Won" if status reason is Won but if not gives me the current sales stage.

    What I want this column of data to look like is below

    Current Sales Stage (Q)---Status Reason (R)--- COMBINED COLUMN
    Prospect---Lost --- Prospect
    Prospect---Won--- Won
    Prospect---In Progress---- Prospect
    Gate 4 ---Cancelled-Customer --- Gate 4
    Prospect---Won --- Won
    Prospect---Won--- Won
    Prospect---Lost ---- Prospect
    .....

    This is the formula I have tried and it is not working...

    =IFS(Q2="Prospect","Prospect",Q2="Gate 0","Gate 0",Q2="Gate 1","Gate 1",Q2="Gate 2","Gate 2",Q2="Gate 3","Gate 3",Q2="Gate 4","Gate 4",Q2="Preferred Bidder","Preferred Bidder",R2="Won","Won")

    Any ideas?

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365 Insiders
    Posts
    11,053

    Re: Combining two columns if one column satisfies criteria

    Hello nathanwlee. Welcome to the forum.

    I think you will benefit by uploading a representative Excel workbook. Please be sure to include enough data and detail to make things clear. 20 to 30 rows is often sufficient. Show BEFORE and AFTER.

    If you are not familiar with how to do this:

    To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

    be sure to desensitize the data
    • click “Go Advanced” (next to Post Quick Reply – bottom right),
    • scroll down until you see “Manage Attachments”, click that,
    • click “Browse”.
    • select your file(s)
    • click “Upload”
    • click “Close window”
    • click “Submit Reply”
    The file name will appear at the bottom of your reply.
    Dave

  3. #3
    Registered User
    Join Date
    02-12-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    6

    Re: Combining two columns if one column satisfies criteria

    Cheers Dave fixed now

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    West Sussex, UK
    MS-Off Ver
    365 for Mac
    Posts
    5,390

    Re: Combining two columns if one column satisfies criteria

    i have 365 for mac version 2019 16.22
    its working for me

    What version of excel do you have
    Wayne

    if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  5. #5
    Valued Forum Contributor
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010
    Posts
    907

    Re: Combining two columns if one column satisfies criteria

    Isn't it as simple as this?

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    It matches the expected results and it even works for us with pre-365 Excel

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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