Memo: Re: OT Excel expert required

[nicholas.dowell@xxxxxxx]

Paul,
     try using the Advanced Filter function in Data.
Click on the Data drop
down, highlight filter and then Advanced Filter.
Once there check on the unique records only box, click on the copy to
another
location and highlight your entire area as the list range, then click ok -
this
should work

Let me know if you want more.

Regards

Nick






"paul_watkin" <paul_watkin@xxxxxxx> on 11 Jun 2002
16:02
                                                                               
                                                                               
                                                                               



To:   ukha_d@xxxxxxx
cc:     (bcc: Nicholas DOWELL/HIBM/HSBC)
Subject:  [ukha_d] OT Excel expert required





Afternoon all,

I have a 3K row excel file (containing business card details) which I
need scan for duplications, which I am pretty sure there are plenty
of!!

Anyone know a very quick and easy method/utility

Cheers

Paul



For more information: http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx
Subscribe:  ukha_d-subscribe@xxxxxxx
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
List owner:  ukha_d-owner@xxxxxxx
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




***************************************************************************
This message originated from the Internet. It's originator
may, or may not be who they claim to be, and the information
contained herein may, or may not be accurate.
***************************************************************************







_____________________________________________________

This transmission has been issued by a member of the HSBC Group 
("HSBC") for the information of the addressee only and should not
be 
reproduced and / or distributed to any other person. Each page 
attached hereto must be read in conjunction with any disclaimer which 
forms part of it. This transmission is neither an offer nor the
solicitation 
of an offer to sell or purchase any investment. Its contents are based 
on information obtained from sources believed to be reliable but HSBC 
makes no representation and accepts no responsibility or liability as to
its completeness or accuracy.



For more information: http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.