+ Reply to Thread
Results 1 to 3 of 3

Textjoin with Multiple If conditions in same range

  1. 03-23-2022, 03:48 AM #1
    saxena_mk
    saxena_mk is offline
    Registered User
    Join Date
    04-14-2019
    Location
    Singapore
    MS-Off Ver
    Office 365
    Posts
    20

    Textjoin with Multiple If conditions in same range

    Hi,

    I am trying to use textjoin formula in office 365 excel with multiple if condition in same range . Please see attached excel

    Two if criteria with following formula is not working
    =TEXTJOIN(" | ",TRUE,IF((C3:C200="Mandatory")*(C3:C200="Optional"),B3:B200,""))


    Range(B2:B23) C2:C23
    Field Name FieldType
    Gift Card Type Mandatory
    Card Design Optional
    Gift Card Amount Mandatory
    Delivery Mandatory
    To Email Mandatory
    From Optional
    Message Optional
    Quantity Optional
    Delivery Date Optional
    Cart Validate Validation
    Submit PMandatory
    PositiveMsg ValidationP
    Negative Msg ValidationN
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-23-2022, 03:55 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Textjoin with Multiple If conditions in same range

    Your formula, the bit in red means AND... you can not have mandatory AND optional... use:
    =TEXTJOIN(" | ",TRUE,IF((C3:C200="Mandatory")*(C3:C200="Optional"),B3:B200,""))


    =TEXTJOIN(" | ",TRUE,IF((C3:C200="Mandatory")+(C3:C200="Optional"),B3:B200,""))

    where + means OR
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 03-23-2022, 05:19 AM #3
    saxena_mk
    saxena_mk is offline
    Registered User
    Join Date
    04-14-2019
    Location
    Singapore
    MS-Off Ver
    Office 365
    Posts
    20

    Re: Textjoin with Multiple If conditions in same range

    Excellent Glenn. It is solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Can I dynamically reference the same cell across multiple worksheets in IF and TEXTJOIN?
    By arsenalmom in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-21-2021, 01:08 PM
  2. [SOLVED] Using TEXTJOIN with INDEX/UNIQUE/SEQUENCE to combine range in batches
    By Brawnystaff in forum Office 365
    Replies: 4
    Last Post: 10-23-2021, 07:26 PM
  3. TextJoin to get coma seperated list from a range of Items randomly
    By saxena_mk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2021, 01:17 PM
  4. [SOLVED]Using TEXTJOIN with multiple criterions
    By Big_Excel_Noob in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2019, 08:57 PM
  5. Use two conditions in textjoin function in excel 2013.
    By magfas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2018, 04:42 PM
  6. [SOLVED] TEXTJOIN with multiple criteria
    By Allerdrengen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-25-2018, 09:22 AM
  7. Return value from multiple entries, within date range, multiple columns, and conditions
    By jeremymc7 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-14-2012, 01:18 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1