Macro to Delete Rows based on Specific Conditions

Hi,

I have a page of paralell lines. The slopes are listed in column A. I need to make a macro that keeps only the lines that match the first 3 slopes.

Please see the attached worksheet.

So, in the worksheet attached, the only lines that would be left after running the macro would be the ones with slopes of -0.04, -0.03 and -0.18. I've highlighted them for clarity.

What's the best approach to this. Is it even possible?

oH, oH, i found a special case. If the first 3 slopes match then this macro doesn't do exactly what I need

to be more precise:
I need to make a macro that keeps only the lines that match the first 3 "UNIQUE" slopes.

can a simple change be made to accomodate this?

Try this :

Please Login or Register  to view this content.

Please click the * below if this helps

Excellent thanks. Just doesn't like it if there are less than 3 unique slopes.

Nice. Wow, you can do almost anything with programming, hey?

I'm having problems with some data having way too many parallel matches though.

I'm interested in seeing the first 3 unique slopes and instead of all their matches, just the first one? So only 6 lines would be left.

Is that easy to do?