Unique List From 2 Columns
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Unique List From 2 Columns
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unique List From 2 Columns

    ...if you have column headings, you may need to use...
    =IF(COUNTIF(B:B,A=0,A2,"")

    Basically, this will only show values in Column C if they don't appear in Col C.

  2. #12
    Board Regular
    Join Date
    Nov 2013
    Posts
    623
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unique List From 2 Columns

    A B C D
    32 11 11
    45 12 34
    12 34 51
    51
    51
    32
    Column A data A2:A5
    Column B data B2:B7
    ARRAY Formula in D2 then copied down

    Code:
    =IFERROR(INDEX($B:$B,SMALL(IF((COUNTIF($D$1:$D1,$B$2:$B$7)=0)*COUNTIF($A$2:$A$4,$B$2:$B$7)=0),ROW($B$2:$B$7),""),ROWS($D$2:$D2))),"")
    How ARRAY formula is entered


    Paste Formula in the cell.
    Press F2
    Hold Shift+ Ctrl Keys and hit Enter key.
    Now the formula is surrounded by {} by excel.
    Last edited by kvsrinivasamurthy; Jul 1st, 2019 at 11:45 AM.

  3. #13
    Board Regular
    Join Date
    Nov 2013
    Posts
    623
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unique List From 2 Columns

    Formula given in previous post does not work properly.
    Here is the revised formula.

    Code:
    =IFERROR(INDEX($B:$B,SMALL(IF((COUNTIF($D$1:$D1,$B$2:$B$7)=0)*COUNTIF($A$2:$A$4,$B$2:$B$7)=0),ROW($B$2:$B$7),""),1)),"")

  4. #14
    Board Regular
    Join Date
    Nov 2013
    Posts
    623
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unique List From 2 Columns

    If numbers in both list are required.

    A B C D
    32 11 11
    45 12 34
    12 34 51
    51 45
    51
    32


    ARRAY formula in D2

    Code:
    =IFERROR(INDEX($B:$B,SMALL(IF((COUNTIF($D$1:$D1,$B$2:$B$7)=0)*(COUNTIF($A$2:$A$4,$B$2:$B$7)=0),ROW($B$2:$B$7),""),1)),IFERROR(INDEX($A:$A,SMALL(IF((COUNTIF($D$1:$D1,$A$2:$A$4)=0)*(COUNTIF($B$2:$B$7,$A$2:$A$4)=0),ROW($A$2:$A$4),""),1)),""))

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •