I have to use Excel 97. I have downloaded information to a spredsheet with 3000+ records, some of which are duplicated. I need to delete all duplicated entries, but cannot afford the time to tab down each record checking for duplicate entries. Excel 2003 has a simple process, but this doesn't apply to Excel 97. please assist.
Frank Kabel - 14 Jul 2004 05:47 GMT
Hi
see:
http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows
and
http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates

Signature
Regards
Frank Kabel
Frankfurt, Germany
> I have to use Excel 97. I have downloaded information to a
> spredsheet with 3000+ records, some of which are duplicated. I need
> to delete all duplicated entries, but cannot afford the time to tab
> down each record checking for duplicate entries. Excel 2003 has a
> simple process, but this doesn't apply to Excel 97. please assist.