The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: OT Excel expert required



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.

Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.