List Info

Thread: How to delete duplicate rows




How to delete duplicate rows
user name
2006-05-26 17:16:48
Hi

This is my first time posting here after finding out about
it at the 
Execl User conference in Atlantic City, which was superb.  

You can delete duplicate rows using Data, Filter, Advanced
Filter and 
checking the box "Unique Records Only"  I
usually make a copy of the sheet 
and then run the filter on the duplicate.  Like to have a
backup to ease my 
mind. 

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )