+ Reply to Thread
Results 1 to 9 of 9

Extracting Unique Values From Two Lists

  1. 05-09-2022, 06:32 PM #1
    jk2391
    jk2391 is offline
    Registered User
    Join Date
    04-03-2020
    Location
    NYC
    MS-Off Ver
    365 Pro Plus
    Posts
    72

    Question Extracting Unique Values From Two Lists

    Hi All,

    Attached is a simple workbook illustrating the problem I'm trying to solve.

    Essentially I have two lists of data with possible duplicate values.

    I can use =UNIQUE to extract the distinct values from column 1, but then I need to somehow list all the unique values in column 2 that are tied to the each value of column 1.

    I'm sure this is a simple XLOOUP/TEXTJOIN formula or something like that, but I'm stumped on this.

    Any help would be great. Thanks!
    Attached Files Attached Files
    Last edited by jk2391; 05-10-2022 at 09:36 AM. Reason: Solved
    Reply With QuoteRegister To Reply
  2. 05-09-2022, 07:55 PM #2
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,415

    Re: Extracting Unique Values From Two Lists

    Cell F4 formula , Drag down
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 05-10-2022, 08:03 AM #3
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Extracting Unique Values From Two Lists

    Similar option
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 05-10-2022, 08:05 AM #4
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Extracting Unique Values From Two Lists

    If you have the Lambda function, you can do both columns at once with
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 05-10-2022, 08:51 AM #5
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,292

    Re: Extracting Unique Values From Two Lists

    Power Query
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 05-10-2022, 09:37 AM #6
    jk2391
    jk2391 is offline
    Registered User
    Join Date
    04-03-2020
    Location
    NYC
    MS-Off Ver
    365 Pro Plus
    Posts
    72

    Re: Extracting Unique Values From Two Lists

    Thanks! Simple and works.
    Reply With QuoteRegister To Reply
  7. 05-10-2022, 09:38 AM #7
    jk2391
    jk2391 is offline
    Registered User
    Join Date
    04-03-2020
    Location
    NYC
    MS-Off Ver
    365 Pro Plus
    Posts
    72

    Re: Extracting Unique Values From Two Lists

    Thanks for the help!
    Reply With QuoteRegister To Reply
  8. 05-10-2022, 09:46 AM #8
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Extracting Unique Values From Two Lists

    Glad to help & thanks for the feedback.
    Reply With QuoteRegister To Reply
  9. 05-10-2022, 07:02 PM #9
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,415

    Re: Extracting Unique Values From Two Lists

    @jk2391 You're Welcome. Glad to help . Thank You for the feedback and rep.
    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] Extracting Unique Values
    By ManchesterMan in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 04-14-2022, 08:37 AM
  2. [SOLVED] Removed duplicate values from 2 lists to give only the unique values in list 3
    By t0mrogers in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-16-2021, 11:58 AM
  3. Excel VBA: Multi-level dependant lists ComboBoxes. some problem in extracting unique lists
    By talha.ansari in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-27-2021, 10:40 AM
  4. Validation Lists - Multiple dependent lists with unique values
    By Lewigi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 06:42 AM
  5. LISTS! identifying unique values in multiple lists
    By pwall1115 in forum Excel General
    Replies: 3
    Last Post: 04-09-2013, 03:36 AM
  6. [SOLVED] LISTS! how to identify which values are unique in multiple lists
    By pwall1115 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-08-2013, 10:43 PM
  7. Extracting Unique Values
    By Drgenetix in forum Excel General
    Replies: 4
    Last Post: 08-04-2011, 06:38 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1