+ Reply to Thread
Results 1 to 3 of 3

Returning text values into a single comma separated cell based upon criteria

  1. #1
    Registered User
    Join Date
    02-16-2015
    Location
    California
    MS-Off Ver
    Excel for Mac 2011 V 14.4.7
    Posts
    31

    Returning text values into a single comma separated cell based upon criteria

    I've seen on some tutorials online that this is possible, but I do not have "SINGLECELLEXTRACT" or "TEXTJOIN" available to me on Excel for Mac 2011 or 2016, nor on my Quip Spreadsheet. Is this possible using Excel for Mac (either version)?

    What I'm trying to do is return the values of column B in a single, comma separated cell (column E), when the values in column A meet the criteria of column D.

    Thanks,
    Jeff



    Screen Shot 2018-10-31 at 12.27.24.png

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Returning text values into a single comma separated cell based upon criteria

    Without textjoin, please try this at E4 Press Ctrl+Shift+Enter and drag down

    I'm not sure is it the same for Mac to press array enter.


    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Returning text values into a single comma separated cell based upon criteria

    Here is VBA solution:
    Use this regular formula to get unique list from column A
    Enter in D4 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    1. Copy code below
    2. Press Alt and F11 on your keyboard to open VB Editor
    3. Click on Insert and select Module
    4. Paste code into Module and close VB Editor.

    Don't forget to save your worbook as Macro-Enabled workbook.
    Please Login or Register  to view this content.
    Use this UDF TEXTJOIN function: Enter in E4 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by AlKey; 10-31-2018 at 04:25 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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. Replies: 16
    Last Post: 02-21-2017, 02:10 AM
  2. Replies: 2
    Last Post: 12-07-2015, 09:04 PM
  3. Returning Multiple Values Separated by Commas to a single cell
    By enragedpigeon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2015, 05:48 PM
  4. [SOLVED] Using comma separated values in a single cell
    By joerobb in forum Excel General
    Replies: 7
    Last Post: 01-16-2015, 08:45 AM
  5. Replies: 3
    Last Post: 12-23-2013, 12:32 PM
  6. [SOLVED] Single cell Comma Separated Values to validation list [DIFFICULT QUESTION]
    By jgema in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-31-2013, 08:48 PM
  7. Sum values based on multiple criteria (comma delimited) in a single cell
    By leem888 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-07-2011, 02:49 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1