+ Reply to Thread
Results 1 to 6 of 6

TextJoin but removing duplicates and ignoring blanks

Hybrid View

  1. 04-15-2023, 07:21 PM #1
    bsalv
    bsalv is offline
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,439

    Re: TextJoin but removing duplicates and ignoring blanks

    a guess
    =TEXTJOIN(" ",1,UNIQUE(TEXTSPLIT(TEXTJOIN(" ",,filter(AC2:AC44,H2:H44="yes")," "),TRUE))
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
    Reply With QuoteRegister To Reply
  2. 04-16-2023, 04:00 AM #2
    HSV
    HSV is offline
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    860

    Re: TextJoin but removing duplicates and ignoring blanks

    There is missing a bracket @bsalv.

    =TEXTJOIN(" ",1,UNIQUE(TEXTSPLIT(TEXTJOIN(" ",,filter(AC2:AC44,H2:H44="yes"))," "),TRUE))
    Harry.
    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. TEXTJOIN IF (Removing Duplicates)
    By Pokermonster in forum Excel General
    Replies: 1
    Last Post: 02-02-2021, 01:46 PM
  2. [SOLVED] Count duplicates in a range ignoring blanks
    By bjnockle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-14-2021, 12:37 AM
  3. Removing duplicates from a TEXTJOIN
    By CKPHarry in forum Excel General
    Replies: 5
    Last Post: 01-02-2020, 05:57 PM
  4. Copy Columns A to F into H, ignoring any duplicates or blanks.
    By OSP67 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-25-2019, 08:05 AM
  5. [SOLVED] SUMIF, ignoring blanks and find earliest date ignoring blanks
    By Chris_Devon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2019, 10:16 AM
  6. [SOLVED] Polulating another tab/sheet bsaed on a criteria, but ignoring/removing blanks
    By gusman2x in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2014, 01:45 PM
  7. Dynamic named range, ignoring duplicates and blanks, WITHOUT VBA
    By aimanti in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-23-2013, 06:13 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1