Results 1 to 3 of 3

De-duping and changing code for dupes

Threaded View

  1. 12-11-2011, 11:47 AM #3
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,236

    Re: De-duping and changing code for dupes

    Hi annes and welcome to the forum,

    I don't think you need VBA for this. A helper column with this at the top and then pull it down might work.
    =COUNTIF(A$1:A2,A2)
    See the attached.

    All helper column numbers of 2 are duplicates of above. You could sort by the helper and then delete the dups if that is what you want.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    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)

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