[WriteLog] FD Dupe Sheet

[arholub]

I guess there are brute force ways and others more elegant!!  Hi
Hi Hi.....  I.e., if there's a hard way to do something, I'll
find it!!!

Doc


----- Original Message ----- 
From: "David O Hachadorian" <k6ll at juno.com>
To: <writelog at contesting.com>
Sent: Tuesday, June 29, 2004 2:27
Subject: Re: [WriteLog] FD Dupe Sheet


>
>
> On Tue, 29 Jun 2004 00:53:28 -0000 "arholub"
<arholub at ix.netcom.com>
> writes:
> > To get my dupe sheet, opened WriteLog and created a contest
report in
> > "Save as ARRL format."  Then opened this file in Microsoft
Excel.
> > It imported nicely in separate columns when I just kept
following
> > the import wizard.  Then Sorted by the call sign column.
Then
> > entered the formula "if(a2=a1,1,0)" (depending upon which
column the
> > call signs are in)in a new column and copied this formula
down the
> > entire column.  This gave me a "1" in any row that had a dupe
and a
> > "0" where no dupe.  Then "saved as" a msdos text file and got
a
> > single file of just call signs.  (I didn't remove the dupes,
but
> > will before I submit it).
>
> What's wrong with file/export/file version of dupe sheet?
>
> Dave Hachadorian, K6LL
> Big Bear Lake, CA
>
> _______________________________________________
> WriteLog mailing list
> WriteLog at contesting.com
> http://lists.contesting.com/mailman/listinfo/writelog
> WriteLog on the web:  http://www.writelog.com/