+ Reply to Thread
Results 1 to 6 of 6

Finding duplicate values in two columns

  1. #1
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    Office 2021
    Posts
    203

    Finding duplicate values in two columns

    Hi All,

    Have two columns.

    I am trying to find out what values are in both column A and column B.

    I would like to show in column C what values ARE NOT in both columns.

    Please see attached for example.
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Finding duplicate values in two columns

    =IFERROR(INDIRECT(TEXT(SMALL(IF((COUNTIF(RNG,RNG)=1)*(COUNTIF($F$1:F1,RNG)=0),ROW(RNG)*10000+COLUMN(RNG)),ROWS($F2:F$2)-COUNTA($F$1:F1)),"R000000C0000"),0),"") as array formula
    smth is wrong with data
    i changed some values
    RNG is a name for your range
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-26-2016
    Location
    São Paulo - Brazil
    MS-Off Ver
    2016
    Posts
    48

    Re: Finding duplicate values in two columns

    Forestavekids

    My contribution

    Put the data in column A2 and B2 and in C2 put formula

    =IFERROR(INDEX(A$2:A$161,MATCH(0,IF(ISNA(MATCH(A$2:A$161,B$2:B$161,0)),COUNTIF(C$1:C1,A$2:A$161)),0)),"")&""


    Decio

  4. #4
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    Office 2021
    Posts
    203

    Re: Finding duplicate values in two columns

    deciog,

    I can't seem to get this past row 160 in column C?
    Last edited by jeffreybrown; 05-29-2017 at 07:21 PM. Reason: Removed full quote!

  5. #5
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    Office 2021
    Posts
    203

    Re: Finding duplicate values in two columns

    tim201110,

    I can't seem to get this past row 160 in column C?
    Last edited by jeffreybrown; 05-29-2017 at 07:21 PM. Reason: Removed full quote!

  6. #6
    Registered User
    Join Date
    03-26-2016
    Location
    São Paulo - Brazil
    MS-Off Ver
    2016
    Posts
    48

    Re: Finding duplicate values in two columns

    The formula is typed CTRL + SHIFT + ENTER

    Decio
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA for finding duplicate values in 4 columns? #Stumped
    By RedditGold in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-14-2017, 04:01 PM
  2. Finding duplicate rows based on values in multiple columns
    By jamie1985 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-03-2014, 08:21 AM
  3. Finding duplicate values
    By sagar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2014, 06:12 PM
  4. Finding duplicate values
    By sagar in forum Excel General
    Replies: 2
    Last Post: 02-23-2014, 03:39 AM
  5. Finding Duplicate Values in Multiple Columns
    By krissyboy78 in forum Excel General
    Replies: 3
    Last Post: 01-04-2013, 09:36 AM
  6. Finding Duplicate Values in a Col,
    By Rajkumar in forum Excel General
    Replies: 2
    Last Post: 03-05-2008, 09:33 AM
  7. finding duplicate cells in different columns?
    By gurj_sandhu in forum Excel General
    Replies: 1
    Last Post: 12-21-2006, 10:53 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1