+ Reply to Thread
Results 1 to 3 of 3

Identify Unique Values from 2 colums

  1. #1
    Registered User
    Join Date
    01-04-2020
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    35

    Identify Unique Values from 2 colums

    Hello everyone,

    I am struggling to come up with a formula to find every unique value between two different columns. I would want it to identify a unique number only if it is unique between the two columns i.e if there is a number that, when both columns were put together, still is only shown once it would be considered unique. It would not be considered unique if it is unique in one column but can be found in another column as well.

    The ultimate goal is to identify these so I can delete them out and see the same numbers essentially in both columns. I can't do conditional formatting and filter because my data is 60,000+ rows long and it just won't work.

    I am perfectly fine with some sort of helper column. Thanks!!!!

    P.S. there is another forum I posted this on... https://www.mrexcel.com/board/thread.../#post-5434390
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    26,704

    Re: Identify Unique Values from 2 colums

    Hi

    Are columns B & D the results you expect from a formula?

    If so can you explain why in column A 5415 is a Y, whereas 548 & 5555 which are also unique
    Similar anomalies occue when comparing column C with column A
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-04-2020
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Identify Unique Values from 2 colums

    This is actually something that is exported from a program at work that has discrepancies between two "views". I am working to identify which (of those that contain the same ID) contain discrepancies in the "Y" or "N". Thanks!

+ 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. Identify & extract unique values
    By panyagak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2017, 03:27 AM
  2. Match unique values between two colums
    By IL_Lee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2013, 07:19 AM
  3. Identify Unique values in Table
    By jyothijayanna in forum Excel General
    Replies: 11
    Last Post: 03-16-2013, 05:57 PM
  4. Identify unique values between 2 columns
    By penfold in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2012, 02:27 PM
  5. group unique values on multiple colums
    By sharmaremuk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-21-2011, 03:10 AM
  6. Replies: 0
    Last Post: 01-14-2010, 04:33 PM
  7. [SOLVED] Identify and count unique values
    By mabond in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2006, 10:00 PM

Tags for this Thread

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