+ Reply to Thread
Results 1 to 4 of 4

Find Unique values compare to other column

  1. #1
    Registered User
    Join Date
    04-20-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2016
    Posts
    13

    Find Unique values compare to other column

    Dear Expert,

    I have two columns A&B for duplicate values. I want to find unique values for column A in compare to Column B and unique values for Column B compare to column A.

    Can I do that by UNIQUE and FILTER function?
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,807

    Re: Find Unique values compare to other column

    It seems you must be on Excel Version MS365 if you're using UNIQUE. Please update your profile.

    In D2, try:
    =FILTER(A2:A8,COUNTIFS(B2:B8,A2:A8)=0)
    In E2, try:
    =FILTER(B2:B8,COUNTIFS(A2:A8,B2:B8)=0)

  3. #3
    Registered User
    Join Date
    04-20-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2016
    Posts
    13

    Re: Find Unique values compare to other column

    Wow, that's Great!

    Thanks a lot.

    One thing that confuses me, in countifs why you put another criteria range in criteria1. We should put only a criteria there not a range, right?

    Could please explain how that is working.

  4. #4
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,807

    Re: Find Unique values compare to other column

    COUNTIFS(B2:B8,A2:A8) is counting all the cells in B2:B8 that are equal to any of the cells in A2:A8

+ 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. [SOLVED] Find unique values in a row and insert a row after every unique value in a column
    By arjunjshetty in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-16-2020, 11:24 AM
  2. [SOLVED] compare values from 2 columns and display the unique values in other column
    By smatbis in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-20-2017, 09:58 AM
  3. Compare and identify unique column values from different workbooks
    By la_chua29 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2015, 02:30 PM
  4. Compare and identify unique column values from different workbooks
    By la_chua29 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2015, 12:40 PM
  5. Replies: 8
    Last Post: 09-12-2013, 09:17 AM
  6. Compare 2 columns of data and get unique values in the 3rd column
    By Eduard in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 04-04-2013, 08:32 AM
  7. [SOLVED] Compare two columns and list the unique values in 3rd column
    By jewellove in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2013, 10:40 AM

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