+ Reply to Thread
Results 1 to 6 of 6

Remove duplicates from each column one at a time

  1. #1
    Registered User
    Join Date
    10-18-2013
    Location
    Atlanta, GA, USA
    MS-Off Ver
    Excel 2016
    Posts
    13

    Remove duplicates from each column one at a time

    Hi, I have a sheet that contains multiple columns of data. Each column is unique and must stand alone. I need to remove the duplicates from each column individually (meaning removing the duplicates from column A can't affect column B, but then I need to remove duplicates in column B, then C, then D, ETC...). I do not know how to write macros and am currently doing this one column at a time.

    I am using MS Excel 2013.

    Go Badgers!!!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,173

    Re: Remove duplicates from each column one at a time

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-18-2013
    Location
    Atlanta, GA, USA
    MS-Off Ver
    Excel 2016
    Posts
    13

    Re: Remove duplicates from each column one at a time

    Thanks JieJenn, however, it isn't working. It's not doing anything (that I can tell).

    Go Badgers!!!

  4. #4
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,173

    Re: Remove duplicates from each column one at a time

    Can you attach your file?

  5. #5
    Registered User
    Join Date
    10-18-2013
    Location
    Atlanta, GA, USA
    MS-Off Ver
    Excel 2016
    Posts
    13

    Re: Remove duplicates from each column one at a time

    JieJenn, Thank you! I didn't realize your macro was only built for certain columns. I was able to modify your original macro to fit my needs.

    Thanks Again!

    Go Badgers!!!

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,869

    Re: Remove duplicates from each column one at a time

    Hi smoking,

    See if this code does what you want:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by MarvinP; 04-03-2015 at 11:14 AM.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say 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. Replies: 5
    Last Post: 05-08-2014, 07:24 AM
  2. remove duplicates in column
    By MsLilly in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-29-2009, 01:08 PM
  3. How to remove duplicates from a column
    By LLocal in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-13-2009, 05:44 PM
  4. Remove duplicates in column D
    By maxebi in forum Excel General
    Replies: 3
    Last Post: 03-02-2009, 02:36 AM
  5. How to remove duplicates from a column
    By wali in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-14-2008, 11:33 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