Click here to Skip to main content
15,878,430 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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.
Posted

1 solution

Not sure of the question, you just need to loop from BOTTOM TO TOP. Or just record a macro using the built in remove duplicates...
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900