Delete Duplicate Rows

[Rock_boy]

G'day, I'm trying to merge a new and an old dataset which have alot of values the same but a few new updated ones, the values don't match on each row but if there is a duplicate value column K that matches a value in column A I need a way to delete the row of data attached to column A while leaving the column K value as is i.e. delete a-j but not the whole row.
Either VBA or a formula would help me out alot.

Cheers

Geoff

[JieJenn]

If you click on Data Ribbon > Data Tool, there is a Remove duplicates function which deletes all the duplicated rows.

[Rock_boy]

Yeah that doesn't work for this, it deletes the whole row or just the column K value i need it to just wipe out column a-j for the matching sample

[JieJenn]

Can you post a sample along with what the final output will look like

[Rock_boy]

E42D1000402 36332.94 86191.257 E42D100047 E42D1000 0.039999999
E42D1000403 36332.871 86191.662 E42D100049 E42D1000 0.029999999
E42D1000404 36332.801 86192.067 E42D100056 E42D1000 0.239999995
E42D1000405 36332.732 86192.472 E42D1000402 E42D1000 0.860000014
E42D1000406 36332.663 86192.877 E42D100096 E42D1000 0.730000019
So i need Column A matched against any values in column D in this case then any matches I need A-C deleted on the matching row (highlighted in red)

[Rock_boy]

Seems simple but I can't figure it out

[jraj1106]

Hello...

It will be a great help if you upload a sample data file...

[Trebor76]

Hi Rock_boy,

Try this (initially on a copy of your data in case the results are not as expected):

Please Login or Register  to view this content.

Regards,

Robert

[Rock_boy]

Thanks robert that will do the trick

[Trebor76]

You're welcome and I'm glad to hear it!!