[WriteLog] FD Dupe Sheet

[David O Hachadorian]

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