Results 1 to 7 of 7

How to conditionally concatenate in Excel 2016

Threaded View

  1. #1
    Registered User
    Join Date
    03-27-2019
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    4

    Exclamation How to conditionally concatenate in Excel 2016

    Hi all,

    I am using Excel 2016 and I want to concatenate values based on their value.

    Basically, imagine a column which contains all the values in different rows. Each row of that column has one value. Some values are positive and some are negative.
    I want to concatenate two values and drag this formula down. However, if one of these two values is negative then I dont want the concatenation. In other words, I want to find the next positive value to apply the formula.

    Can anyone please help me?

    I have attached an example. Column A includes the values and Column B includes what I want.

    Thanks in advance,
    Marios
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Concatenate 2 Dates Conditionally Using Another Cell
    By chiatbw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2017, 08:05 AM
  2. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  3. [SOLVED] Issue send email with excel 2016 true outlook 2016
    By kirana2014 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2017, 11:34 AM
  4. Help! Automated Email coding for Excel 2016 and Outlook 2016 problems
    By lisa6421 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2017, 08:07 AM
  5. [SOLVED] conditionally concatenate values in second table
    By kammend in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-27-2016, 11:44 AM
  6. [SOLVED] How to concatenate mutiple rows and show it in a single Cell Conditionally
    By Kandavalli.Kiran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-04-2015, 04:48 PM
  7. how do i concatenate conditionally formatted cells in excel
    By Sandwiches2 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-13-2006, 09:45 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