Dean, Well, you can develop the filtered list of First Worked within the Excel spreadsheet.
- Open the CSV file with Excel. - Note that "Prefix" is column G. For the sake of this discussion, assume you have 5000 rows of QSOs. - Select <D>ata | <F>ilter... | <A>dvanced Filter. - In the Advanced Filter screen, enter "G2:G5000" for both the List and Criteria range. - Click the <Unique records only> checkbox. - Press <OK> You now have a spreadsheet with one row per the first occurrence of each prefix, based on the date field (they were already listed by date when you got them from DX4WIN). Which means that for each prefix the displayed QSO is the first time you worked it. You can print this list, resort this list by prefix, or copy/paste this list to a new spreadsheet that will only contain the First Worked entry for each prefix. -larry K8UT ----- Original Message ----- From: "Dean Norris" <[EMAIL PROTECTED]> To: "Larry Gauthier" <[EMAIL PROTECTED]>; <[email protected]> Sent: Tuesday, March 12, 2002 6:44 PM Subject: Re: [Dx4win] First Worked > At 10:35 3/12/2002, Larry Gauthier wrote: > >Dean, > > > >If I understand your list requirements correctly, the answer is YES. > > > >Go to: <F>ilter, <P>refix, and enter a prefix of "!K" (which means, anything > >except a "K" prefix QSO - or all non-US QSOs). Press <Enter>. > > > >Go to: <W>indow | Logbook. The Logbook window with now open, displaying all > >DXCC QSOs in order by the date/time worked. > > > >IF you want to manipulate/sort/analyze this data further (such as in Excel), > >right-click in the Logbook window, select "Write to File" and save the data > >in a CSV (comma separated value) file format - which Excel can read > >directly. > > > >-larry > >K8UT > > > Not quite Larry. I only want the first worked for each country, and in the > order worked. > > Thx.. > > Dean > > > -- > >
