+ Reply to Thread
Results 1 to 3 of 3

Criteria for unique values using TEXT JOIN or AGGREGATE with values from another sheet

  1. #1
    Registered User
    Join Date
    03-08-2010
    Location
    Sweden
    MS-Off Ver
    MS Office 365 Mac and Windows
    Posts
    94

    Criteria for unique values using TEXT JOIN or AGGREGATE with values from another sheet

    Hello forum,

    I have been struggle for a while now trying to extract unique values to separate columns (in my example D21, E21, F21, G21, H21 etc as long as it has unique values ) but all samples i find is for filling row by row and I have not been able for it to work for filling one row along columns.
    I then looked at the new function "TEXJOIN", that separate values with an delimiter instead, less stylish but seemed easy to do, but I still struggle when it comes to two criteria and another sheet.

    I have two test functions one with INDEX and AGGREGATE and one with TEXTJOIN, I can pull out one Name but not all of the unique values....
    How would this be solved? I have attached an example and it is in D21-L21 I want the result to be entered if all is needed, TEXTJOIN is less elegant in this solution if nothing else works.

    Thanks
    Attached Files Attached Files
    Last edited by soreno; 11-30-2019 at 02:25 PM.

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

    Re: Criteria for unique values using TEXT JOIN or AGGREGATE with values from another sheet

    Please try at D21

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

  3. #3
    Registered User
    Join Date
    03-08-2010
    Location
    Sweden
    MS-Off Ver
    MS Office 365 Mac and Windows
    Posts
    94

    Re: Criteria for unique values using TEXT JOIN or AGGREGATE with values from another sheet

    @Bo_Ry Excellent!!! I don't know how you could get the head around this, I have been banging my head on the desk trying I will now try it on my worksheet, looks very promising Thanks A LOT!!!

+ 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] Count unique (text) values based on two criteria
    By Gijs in forum Excel General
    Replies: 4
    Last Post: 03-09-2018, 07:50 AM
  2. [SOLVED] Count unique text values with criteria
    By andrugrasu in forum Excel General
    Replies: 11
    Last Post: 09-10-2017, 08:35 AM
  3. [SOLVED] Sum unique text/number values given a criteria
    By Spicey_888 in forum Excel General
    Replies: 2
    Last Post: 08-12-2015, 01:44 AM
  4. Count unique text values using criteria
    By roadbiker in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-27-2013, 12:13 PM
  5. Replies: 3
    Last Post: 07-04-2012, 11:15 PM
  6. Replies: 5
    Last Post: 05-31-2012, 08:48 AM
  7. Count unique text values in range with criteria
    By cdiaz in forum Excel General
    Replies: 3
    Last Post: 07-15-2011, 10:43 AM

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