Eliminate unique entries

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.

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.

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

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

       --A--- ----B---- C --D--- ----E----
   1   Sleeve   MTRS      Sleeve   MTRS   
   2     4243   905,514     4243   905,514
   3                        4244   542,558
   4     4246   842,037     4246   842,037
   5                        4248   919,223
   6                        5247 3,073,811
   7     7418 4,139,684     7418 4,139,684
   8                        7423   424,198
   9     7429 2,025,076     7429 2,025,076
  10                        7436 2,263,868
  11                        7438 2,644,633
  12     7439 1,527,250     7439 1,527,250
  13                        7440   386,001
  14    13270                             
  15    15146                             
  16    15147    53,364    15147    53,364
  17    15148                             
  18    15149                             
  19    15150   207,709    15150   207,709
  20                       15151 2,756,118

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