RE: Re: OT Excel expert required

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

Well... 

create an 88th column so that YY1 = A1 & B1 & C1 &....


.... then sort the whole range on that, then do the compare one-up,
one-down trick...


OR

Use a database :-)


-----Original Message-----
From: paul_watkin [mailto:paul_watkin@xxxxxxx]
Sent: 11 June 2002 16:15
To: ukha_d@xxxxxxx
Subject: [ukha_d] Re: OT Excel expert required


Hi Mark,

thanks for your response, unfortunately I forgot the important bit, a 
row is only considered a duplicate if all the columns are identical 
and there are 87 columns in the sheet!

And no I can't gaurantee all 87 will be identical

cheers

Paul

--- In ukha_d@y..., "Mark Harrison" <Mark.Harrison@e...>
wrote:
> 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@n...]
> 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@y... 
> Subscribe:  ukha_d-subscribe@y... 
> Unsubscribe:  ukha_d-unsubscribe@y... 
> List owner:  ukha_d-owner@y... 
> 
> 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 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.