+ Reply to Thread
Results 1 to 3 of 3

Subtracting Duplicates

  1. #1
    Registered User
    Join Date
    09-07-2016
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Subtracting Duplicates

    Hello everyone,

    I was given an excel sheet with two columns:

    Column A: 3,000 Names
    Column B: 7,000 Names

    I was told to remove names of people who appear both in Column A and Column B (Column B - Column A) so that I would only have a column with unique values.

    ANy help is greatly appreciated.

    Thank you,
    k

  2. #2
    Forum Contributor
    Join Date
    02-04-2014
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Subtracting Duplicates

    For a quick and easy fix, I would copy column B and paste it under column A. Then I would Use the Data tab at the top and remove duplicates

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Subtracting Duplicates

    I have added some code to module1 ALT-F11 to view). Enable macros on opening.

    DEVELOPER/Macros/Run to execute it.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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. Microsoft Excel - Subtracting Duplicates
    By kiminai in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 09-07-2016, 06:42 PM
  2. [SOLVED] Macro to find duplicates, concatenate cells, then delete old duplicates (2)
    By cny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2016, 06:05 AM
  3. Subtracting numbers from column until zero then subtracting from second column
    By JPFranklin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2016, 05:20 PM
  4. Replies: 2
    Last Post: 12-27-2013, 09:24 AM
  5. [SOLVED] Macro to find duplicates, concatenate Unique Values, then delete old duplicates
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2013, 04:32 PM
  6. Replies: 17
    Last Post: 07-05-2011, 05:37 PM
  7. Replies: 3
    Last Post: 03-09-2011, 07:00 PM

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