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
Bookmarks