Remove Duplicate Values

See more:

MS-Excel

macros

VBA

Hi,

My problem is I have large amount of data and need a simple VBA to do the below task. If you give me a start then I can do rest of the work. Kindly check and let me know. Your soonest response is highly appreciated.

if (B1=B2 && C1=C2 && D1!=D2) {

A2="B2,C2,D2"}

}

eles{

}

B2,C2,D2 data should be deleted

Like wise I need to continue till the end of the sheet. Please help me.