删除重复值 [英] Remove Duplicate Values

问题描述

我的问题是我有大量数据，需要一个简单的VBA才能执行以下任务。如果你给我一个开始，那么我可以做其余的工作。请检查并告诉我。非常感谢您的最快回复。



if（B1 = B2 && C1 = C2 && D1！= D2）{


A2 =B2，C2，D2}



}



eles {



}



B2，C2，D2数据应该被删除



同样明智的我需要一直持续到表格的最后。请帮帮我。

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.

推荐答案

不确定问题，你只需要从BOTTOM到TOP循环。或者只使用内置的删除重复项来记录宏...

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...

这篇关于删除重复值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！