Closed Thread
Results 1 to 2 of 2

TEXTJOIN and IF Array

  1. #1
    Registered User
    Join Date
    11-12-2021
    Location
    PNW
    MS-Off Ver
    Office365
    Posts
    4

    TEXTJOIN and IF Array

    Hello,

    I have all the data in one sheet. One set of columns has a name and serial number. There may be multiple listings for the same name but the serial number is unique. What I'm trying to accomplish is to get a list of each unique name in one cell and then all the serial numbers, separated by a comma, in the next cell that correspond to that name

    Bob Smith Serial1,Serial2,Serial3
    Jim Jones Serial 6,Serial10
    etc....

    This is the formula I'm using that doesn't seem to work:

    {=TEXTJOIN(",",TRUE,IF($B$2:$B$1369=H2,$C$2:$C$1369,""))}

    Thanks in advance for any assistance
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,734

    Re: TEXTJOIN and IF Array

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue in Commercial Services, where you have posted the same query.[/I]
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Textjoin Alternative
    By getafixkwik in forum Excel General
    Replies: 10
    Last Post: 04-05-2020, 11:28 AM
  2. Textjoin and if function need help
    By bitozi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2019, 06:35 AM
  3. Error Using TEXTJOIN Function in Array Formula to List Non-empty Strings
    By MikeA01730 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-18-2019, 01:24 AM
  4. TEXTJOIN array for cells with functions in them (bug?)
    By Allerdrengen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-02-2018, 05:24 AM
  5. [SOLVED] How can I modify my array TEXTJOIN formula to output only unique values
    By Victorjo in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-06-2018, 01:50 AM
  6. Textjoin?
    By johandenver in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 10-01-2017, 03:18 PM
  7. TEXTJOIN function
    By Tony Valko in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2016, 06:48 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