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/
|