Does anyone know how to automatically detect and delete duplicate rows in MS Excel?

[秋水长天]

Does anyone know how to automatically detect and delete duplicate rows in MS Excel?

 

[飘在加国]

我记得2007以后的版本有这么一项功能，叫Remove Duplicates楼主可以看看。

 

[秋水长天]

我记得2007以后的版本有这么一项功能，叫Remove Duplicates楼主可以看看。

Will give it a try. Thanks.

 

[uglyducking]

其实我更关心怎么删除duplicated contacts in my address book。
自从由爱刨转为古狗，这个烦恼biu的一下，不见了。

 

[冰中取火]

Does anyone know how to automatically detect and delete duplicate rows in MS Excel?

选中需要处理的区域，Date---Date tool----remove duplicates

 

[kentridge]

i thought you want to build a marco to do it automatically

 

[秋水长天]

It worked. Thanks again.

选中需要处理的区域，Date---Date tool----remove duplicates