Hi
I have a data sheet with over 12000 rows. In column A I have either 104 or 107, in column B I have a lot of number that can be shown under both 104 and 107. In column C I have a document number and in column D I have a number or text string.
what I would like is to delete rows that don't contain the highest document number for where column A, B and D is identical. I have tried to illustrate it below.
e.g.
104 - 400002 - 51000003 - 74 --> keep
104 - 400002 - 51000001 - 74 --> delete
104 - 400001 - 51000002 - 74 --> delete
104 - 400001 - 51000005 - 74 --> delete
104 - 400001 - 51000006 - 74 --> keep
104 - 400001 - 51000007 - BD1 --> keep
107 - 400002 - 51000003 - 74 --> keep
107 - 400002 - 51000001 - 74 --> delete
107 - 400001 - 51000002 - 74 --> delete
107 - 400001 - 51000005 - 74 --> delete
107 - 400001 - 51000006 - 74 --> keep
107 - 400001 - 51000007 - BD1 --> keep
Thanks for your help in advance.
Bookmarks