删除重复记录 [英] Remove Repetitive Record

问题描述

有没有办法从Excel工作表中删除重复的行??
请有人帮忙.我是手动进行的，所以要花很多时间.

Hi, Is there a way to remove repetitive rows from an excel sheet??
please someone help. i am doing it manually and it takes a lot of time.

推荐答案

找到了它，但是没有尝试过:
http://www.cpearson.com/excel/deleting.htm [

Found this, didn''t try it though :
http://www.cpearson.com/excel/deleting.htm[^]

Amongst others, it contains a macro for deliting duplicate rows.

Cheers

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