Re: OT Excel expert required

["paul_watkin" <paul_watkin@xxxxxxx>]

I can't get this too work 100%, I thought initially it was due to the 
number of columns hence the question but think it might have more to 
do with the contents the cells I am comparing not always being 
standard text.

thanks anyway

Paul

--- In ukha_d@y..., "Mark Harrison" <Mark.Harrison@e...>
wrote:
> 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@n...]
> 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@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 the Yahoo! Terms of Service.