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
|