+ Reply to Thread
Results 1 to 3 of 3

Compare two columns and list the unique values in 3rd column

  1. 01-10-2013, 09:49 AM #1
    jewellove
    jewellove is offline
    Forum Contributor
    Join Date
    10-26-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2010
    Posts
    138

    Compare two columns and list the unique values in 3rd column

    Hi!

    What is the formula to compare Column A and Column B. Then list the values that is unique in Column C.
    Please see attachment. Thanks a lot.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-10-2013, 10:03 AM #2
    rcm
    rcm is offline
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Compare two columns and list the unique values in 3rd column

    try the macro
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 01-10-2013, 10:40 AM #3
    Teethless mama
    Teethless mama is offline
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Compare two columns and list the unique values in 3rd column

    A2:A15 - defined name range RngA
    B2:B18 - defined name range RngB


    C2: =IFERROR(IFERROR(INDEX(RngA,MATCH(,IF(ISNA(MATCH(RngA,RngB,)),COUNTIF(C$1:C1,RngA)),)),INDEX(RngB,MATCH(,IF(ISNA(MATCH(RngB,RngA,)),COUNTIF(C$1:C1,RngB)),))),"")

    Ctrl+Shift+Enter, not just Enter
    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)

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