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@juno.com>
To: <writelog@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@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@contesting.com
> http://lists.contesting.com/mailman/listinfo/writelog
> WriteLog on the web: http://www.writelog.com/
_______________________________________________
WriteLog mailing list
WriteLog@contesting.com
http://lists.contesting.com/mailman/listinfo/writelog
WriteLog on the web: http://www.writelog.com/
|