+ Reply to Thread
Results 1 to 5 of 5

Concatenate with IF

Hybrid View

Wodin Concatenate with IF 10-22-2022, 10:15 AM
6StringJazzer Re: Concatenate with IF 10-22-2022, 10:23 AM
Wodin Re: Concatenate with IF 10-22-2022, 10:28 AM
etaf Re: Concatenate with IF 10-22-2022, 10:29 AM
6StringJazzer Re: Concatenate with IF 10-22-2022, 11:33 AM
  1. #1
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,101

    Re: Concatenate with IF

    as you have 365 textjoin
    maybe this
    =TEXTJOIN(",",TRUE,IF(A1:E1>0,TEXT(A1:E1,"dd/mm/yy"),""))
    Attached Files Attached Files
    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.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,768

    Re: Concatenate with IF

    Quote Originally Posted by etaf View Post
    as you have 365 textjoin
    maybe this
    =TEXTJOIN(",",TRUE,IF(A1:E1>0,TEXT(A1:E1,"dd/mm/yy"),""))
    This is better than mine.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Vlookup and Concatenate or INDEX/MATCH and Concatenate
    By naumanxkhan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2020, 09:44 PM
  2. Auto concatenate and reverse concatenate & Remove duplicates .
    By Andy308 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2016, 12:38 PM
  3. Concatenate with Double Info in Concatenate Cell
    By MRoz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2015, 02:07 PM
  4. Replies: 5
    Last Post: 08-28-2014, 06:01 PM
  5. [SOLVED] VBA concatenate script does not excute as expected, Concatenate and "&" can't be dragged
    By VBAlex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2014, 09:25 AM
  6. Replies: 2
    Last Post: 04-12-2010, 12:35 PM
  7. [SOLVED] [SOLVED] I know how to concatenate ,can one de-concatenate to split date?
    By QUICK BOOKS PROBLEM- in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-26-2005, 01:05 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