Trim Duplicates

**stockgoblin42** · 06-15-2013, 07:20 AM

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

**martindwilson** · 06-15-2013, 08:00 AM

there are 550 pairs of unique values in column do you just want the first 7?

**stockgoblin42** · 06-15-2013, 08:22 AM

yes, the first 7 slopes, including a duplicate's match if it's encountered in the first 7 lines.

I tried just taking the first seven lines and getting their index matches but if the index match for, say line 2 is on line 4, then that doesn't work.

**stockgoblin42** · 06-15-2013, 08:47 AM

okay, here's less sample data with that problem, a duplicate's match within the first seven lines...

**Marcol** · 06-15-2013, 09:15 AM

I don't know which sheet you are referring to.

This workbook lists the unique values in Sheet2 Column A that have a duplicate within 7 rows of the first instance found.

Is that what you mean?

**stockgoblin42** · 06-15-2013, 09:31 AM

no sorry, it's much simpler than that.

the sampledata is a list of pairs or triplicates, etc.. of paralell lines, slope values in Column A. There are too many. I want to only see the first seven pairs of parallel lines. So, I could just copy the first 7 lines to a new sheet and lookup the second instances of the column A values to give me 14 lines, 7 pairs of paralell lines.

BUT...

that only works if the first 7 values in column A are all different from each other. What do I do when they are not?

sorry for the confusion