Find unique values between two columns
Results 1 to 4 of 4

Thread: Find unique values between two columns

  1. #1
    Board Regular
    Join Date
    Sep 2018
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Find unique values between two columns

    Hi All

    I am comparing two columns to find unique values. I have the below but I need help to stop blank cells returning a yes value.

    =IF(ISNA(VLOOKUP(E3,$B$3:$B$7000,1,FALSE)),"Yes","NO")
    I would also like to count the unique values but avoid an array formula. I have the below but not yet working:

    =SUM(1/COUNTIF($E$3:$E$7000, $E$3:$E$7000))+SUM(IF(COUNTIF($E$3:$E$7000, $B$3:$B$7000)=0, 1/COUNTIF($B$3:$B$7000, $B$3:$B$7000), 0))
    Many thanks for any help
    Last edited by horizonflame; Aug 17th, 2019 at 02:10 PM.

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,686
    Post Thanks / Like
    Mentioned
    64 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Find unique values between two columns

    I hope something like this helps you:

     BCDEF
    2DATAUNIQUE DATAUNIQUE
    3data3no data3no
    4data4yes data5no
    5data5no data7no
    6data6yes data9yes
    7data7no data11yes
    8data8yes data13yes

    CellFormula
    C3=IF(COUNTIF($B$3:$B$8,B3)+COUNTIF($E$3:$E$8,B3)=1,"yes","no")
    F3=IF(COUNTIF($B$3:$B$8,E3)+COUNTIF($E$3:$E$8,E3)=1,"yes","no")
    Regards Dante Amor

  3. #3
    Board Regular
    Join Date
    Sep 2018
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Find unique values between two columns

    @DanteAmor thank you very much! Just the overall count formula now to go
    Last edited by horizonflame; Aug 17th, 2019 at 02:53 PM.

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,686
    Post Thanks / Like
    Mentioned
    64 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Find unique values between two columns

    I'm glad to help you. Thanks for the feedback.
    Regards Dante Amor

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
  •