[WriteLog] FD Dupe Sheet

[Art Searle, W2NRA]

Hi Doc,

Am I missing something here?  I didn't work field day, too many honeydews.
But in my limited experience with WriteLog with every module I've used it
prevented duplicates.  Why would you have any dupes?  Am I missing
something, Doc, or are you guilty of WriteLog malpractice?

73,
Art
W2NRA

----- Original Message ----- 
From: "arholub" <arholub at ix.netcom.com>
To: <WriteLog at contesting.com>
Sent: Monday, June 28, 2004 8:53 PM
Subject: [WriteLog] FD Dupe Sheet


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).

Just for info....

Doc
WA6OGO


Visit our web site, www.arholub.com, to get the latest news, computer class
information and Orange Coast College marine course information.
_______________________________________________
WriteLog mailing list
WriteLog at contesting.com
http://lists.contesting.com/mailman/listinfo/writelog
WriteLog on the web:  http://www.writelog.com/