[Dx4win] First Worked

[Larry Gauthier]

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" <dnorris@k7no.com>
To: "Larry Gauthier" <larryg@ismi.net>; <dx4win@mailman.qth.net>
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
>
>
> --
>
>