Hi, I have a list of lines with slopes and Y-intercepts. I'd like to identify all the parralell lines (equal slopes) and copy a few bits of info from those rows to another part of the page. See the highlighted areas in the attached file.
I take it I'll need a macro but how do I filter for duplicates first? Would I used the advanced Filter? What would the Criteria for the Criteria Range be?
Any ideas?
Last edited by stockgoblin42; 04-25-2013 at 04:14 PM.
Try this.
Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks