+ Reply to Thread
Results 1 to 4 of 4

Formula to Extract Unique Values/Remove Duplicates Across Multiple Columns of Data

  1. 08-23-2017, 02:43 PM #1
    Lanceh
    Lanceh is offline
    Registered User
    Join Date
    09-08-2016
    Location
    Rogers
    MS-Off Ver
    2013
    Posts
    13

    Formula to Extract Unique Values/Remove Duplicates Across Multiple Columns of Data

    Good afternoon,

    While I found a work around for my needs now, I thought I'd ask the fine folks here for input for future reference. Is there a formula to extract all the unique values/remove duplicates in columns A through G of the attached sample? I have an index and countif formula to extract the unique values from one column as that is how I arrived at the sample data. I suppose I've just been sniffing too much glue today to figure out how to include the additional columns within the formula. Thanks in advance for your help!

    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-24-2017, 03:37 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Formula to Extract Unique Values/Remove Duplicates Across Multiple Columns of Data

    In I2, copied down:

    =IFERROR(INDIRECT(TEXT(AGGREGATE(15,6,(ROW($A$1:$G$5)*100+COLUMN($A:$G))/(($A$1:$G$5<>"")*(COUNTIF($I$1:I1,$A$1:$G$5)=0)),1),"R0C00"),FALSE),"")
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 08-24-2017, 08:07 AM #3
    Lanceh
    Lanceh is offline
    Registered User
    Join Date
    09-08-2016
    Location
    Rogers
    MS-Off Ver
    2013
    Posts
    13

    Re: Formula to Extract Unique Values/Remove Duplicates Across Multiple Columns of Data

    Nice work, Glenn. Thanks!
    Reply With QuoteRegister To Reply
  4. 08-24-2017, 09:07 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Formula to Extract Unique Values/Remove Duplicates Across Multiple Columns of Data

    You're welcome...
    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] Array Formula to extract all values (both duplicates and unique values in a range in Excel
    By bjnockle in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-27-2016, 07:33 PM
  2. [SOLVED] Count Unique Values with Duplicates in Multiple Columns
    By sTeezZy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-26-2016, 05:50 PM
  3. Extract unique values from multiple columns
    By potejam in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 12-16-2015, 08:26 PM
  4. [SOLVED] How to extract unique values from multiple columns in Excel?
    By chief_abound in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-16-2015, 02:45 AM
  5. Extract data from multiple columns, group and sum up unique values
    By Alcotraz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2015, 06:54 PM
  6. Formula to create a list of unique values / remove duplicates
    By TicklyTigger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-12-2014, 08:39 AM
  7. Macro to remove duplicates values and keep unique values bases on multiple criteria
    By Ricker090 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2011, 04:37 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1