Results 1 to 6 of 6

Trim Duplicates

Threaded View

  1. #1
    Forum Contributor stockgoblin42's Avatar
    Join Date
    05-26-2011
    Location
    vancouver, canada
    MS-Off Ver
    Excel 2010
    Posts
    222

    Trim Duplicates

    Hi,

    I have a list of lines with slope values in column A. Each slope has 1 or more duplicates in this list. I'm trying to figure out a macro that would trim the list down to just the first 7 unique slopes and their first duplicate.

    So the list should be cut down to 14 lines, 7 pairs of lines with duplicate values in column A.

    Is this possible? Can only a genius figure this out?

    oh, watch out for the fact that a duplicate's match may occur within the first 7 lines.
    Also, there's a helper column already in column B.


    here's some sample data.

    any help is appreciated
    Attached Files Attached Files
    Last edited by stockgoblin42; 06-15-2013 at 08:26 AM.
    live logic & long prosper

Thread Information

Users Browsing this Thread

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

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