Delete row if...

[vistrup]

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.

[vistrup]

I found another work around
Using the following =IF(MAX(IF(A:A=A2207;IF(B:B=B2207;IF(D:D=D2207;C:C))))=C2207;"K";"D") and then hit ctrl+shift+enter it is possible to determine if the row needs to be deleted.