duplicate
 

I have spreadsheet that contains about 200,000 records. Many of them are
duplicated. How can I sort them out so that I can only have one of each?

Metalteck wrote:
|| I have spreadsheet that contains about 200,000 records. Many of them
|| are duplicated. How can I sort them out so that I can only have one
|| of each?

have a look he
http://www.cpearson.com/excel/duplic...tingDuplicates

--
Gordon Burgess-Parker
Interim Systems and Management Accounting
www.gbpcomputing.co.uk

ASAP Utilities has a feature that does this nicely..........

Free at www.asap-utilities.com


Vaya con Dios,
Chuck, CABGx3


"Metalteck" wrote in message
...
I have spreadsheet that contains about 200,000 records. Many of them are
duplicated. How can I sort them out so that I can only have one of each?