Results 1 to 6 of 6

How to match duplicate/unique values in two columns?

Threaded View

  1. 06-18-2020, 07:11 AM #1
    jackdanes
    jackdanes is offline
    Registered User
    Join Date
    06-18-2020
    Location
    Cheltenham
    MS-Off Ver
    10 Pro
    Posts
    3

    How to match duplicate/unique values in two columns?

    Hi all,

    I have two columns and have identified duplicate and unique data, but I would like the duplicates (the matches in my case) to sit side by side each other?

    In this sheet, I have 8 columns of 2 where I want this to be done. For example, in the screenshot I would like a,b and c to sit by side by side.

    UPDATE: in the attachment I have two lists of words and would like the duplicates to be next to each other.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by jackdanes; 06-19-2020 at 03:45 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index Match - Return unique results when Lookup Array contains duplicate values
    By STUARTXL in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2017, 08:22 AM
  2. [SOLVED] Trying to match unique values in single column against multiple columns
    By VegasL in forum Excel General
    Replies: 6
    Last Post: 05-26-2016, 11:12 PM
  3. [SOLVED] Need Help Counting Unique Values If 2 Columns Match
    By Xeba37 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-10-2016, 05:29 AM
  4. Compare duplicate values in two columns and highlight if match
    By JEKF in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-18-2015, 12:32 PM
  5. [SOLVED] Find count of Unique or Duplicate Values based on Concatenated values in 2 columns
    By bdicarlo1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2014, 12:42 AM
  6. Excel - If two columns match sum all duplicate values, then delete the duplicates
    By mmack5 in forum Excel General
    Replies: 0
    Last Post: 11-15-2012, 06:47 AM
  7. Add duplicate values for multiple columns from unique data..
    By empyrean in forum Excel General
    Replies: 7
    Last Post: 07-13-2009, 01:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1