RE: OT Excel expert required

["Mark Harrison" <Mark.Harrison@xxxxxxx>]

Paul,

If you can guarantee that your dupes are identical, then it's easy.

Say you're looking for de-dupes on column A... then you do two things.

1: Sort on column A
2: Create a new column, say, B, which does B1 = IF (A1=A2, "DUPE
FOUND", "")... and copy down

You can then to a quick manual scan down to see whether there are any Dupes
by just looking to see non-empty cells in Column B.

That's the way I find dupes in long lists :-)

Mark

-----Original Message-----
From: paul_watkin [mailto:paul_watkin@xxxxxxx]
Sent: 11 June 2002 16:02
To: ukha_d@xxxxxxx
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 email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________


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.