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@ix.netcom.com>
To: <WriteLog@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@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/
|