Eliminate unique entries

[fd1263]

I have an Excel sheet with 5 columns, Column A has numeric values with coinciding numeric data in B. C is empty, D has numeric values with coinciding numeric data in E. I would like to eliminate unique entries from D so I'm left with matching A and D with coinciding data in B and E.

[zbor]

PLease rename your title according to the rules:

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

[martindwilson]

post an example work book please its a lot easier to work on and will give you something to reference

[fd1263]

I have a sample copy of a portion of the spread sheet i am using. Normally column B and E do not have the same mtr. readings for the coinciding sleeve entry. What I'm trying to do is eliminate the unique entries from D so that A and D match.

[shg]

Would code that converts the data (in part) to this be of use?

Please Login or Register  to view this content.

[teylyn]

So you want to delete all entries in columns D and E where the Sleeve no in column D is not also present in column A?

If so, you could put this formula into column F, starting in F3 and copied down

=IF(ISNA(MATCH(D3,$A$3:$A$43,0)),"delete","")

Then sort columns D, E and F by the values in column F and delete the ones that have the entry "delete" in column F. After that, you can delete column F, sort the data gain by column D and all should be matched up.

cheers

[fd1263]

Thank you for the quick reply, This should work very well.