+ 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, Office 365
    Posts
    11,597

    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
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    5,919

    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 an "* Add Reputation" 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
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,253

    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)

Similar Threads

  1. [SOLVED] Return Data that Satisfies Multiple Range Criteria
    By eve.excel in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-08-2017, 02:32 AM
  2. [SOLVED] Pull Information From Multiple Columns That Satisfies Multiple Criteria
    By slindfors in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-01-2015, 04:39 PM
  3. Replies: 2
    Last Post: 03-24-2015, 03:47 PM
  4. Combining data in multiple columns(all columns have same length)into one column
    By nzi0001 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-24-2014, 11:19 AM
  5. Replies: 3
    Last Post: 04-28-2014, 02:24 PM
  6. Identify quantity of unique data that satisfies a particular criteria
    By petermichael in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-07-2013, 09:31 AM
  7. A script that satisfies a condition, to change the input column
    By kostas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2007, 04:28 AM

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