[Ham-Computers] SORTING CALLSIGNS WITH EXCEL

[Ed - K9EW]

Hi Paul,

Just to make sure I understand, are you asking for a blank copy of my
logbook in Excel that you can use?

That's fine with me, I just wanted to be sure I'm sending you the
right thing.  BTW, I also have a column next to the callsign column
that you can click on, and it takes you to the QRZ.com page for that
callsign.  That comes in handy for addressing QSL cards.

So let me know if that's what you're interested in, and I'll send it
to you right away.

73,
ed - k9ew
www.k9ew.us

On Mon, Oct 12, 2009 at 4:56 AM, Paul McInnish <k4bet at bellsouth.net> wrote:
> Can you send me, off line, the 'empty' spread sheet with the various columns
> and the label for each?
>
> Thanks,
>
> Paul - K4BET
> K4bet at bellsouth.net
>
>
> -----Original Message-----
> From: ham-computers-bounces at mailman.qth.net
> [mailto:ham-computers-bounces at mailman.qth.net] On Behalf Of Ed - K9EW
> Sent: Sunday, October 11, 2009 9:07 PM
> To: Computers (or other) used for amateur radio, communications, or
> experimenting
> Subject: Re: [Ham-Computers] SORTING CALLSIGNS WITH EXCEL
>
> Hi Steve,
>
> Well, you were right about Francis, the "Excel Addict".  I sent him an
> email, and within a couple of hours he replied with this solution
> (which works)...
>
> Put this formula in an adjacent column and sort on this column.
>
> =MID(A1,IF(ISNUMBER(VALUE(MID(A1,2,1))),2,IF(ISNUMBER(VALUE(MID(A1,3,1))),3,
> 0)),9)
>
>
> Formula Explanation:
>
> IF(ISNUMBER(VALUE(MID(A1,2,1))),2,
> This part of the formula checks if the 2nd character is a number. If it is,
> it returns 2 (to be used by the MID function).
>
> IF(ISNUMBER(VALUE(MID(A1,3,1))),3,
> This part of the formula checks if the 3nd character is a number. If it is,
> it returns 3 (to be used by the MID function).
>
> =MID(A1,value returned by ISNUMBER function,9)
> The MID function returns 9 characters starting at the number returned by
> ISNUMBER
>
> Hope this is of some use to someone else sometime in the future.
>
> 73,
> ed - k9ew
> ______________________________________________________________
> Ham-Computers mailing list
> Home: http://mailman.qth.net/mailman/listinfo/ham-computers
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:Ham-Computers at mailman.qth.net
>
> List Administrator: Duane Fischer, W8DBF
> ** For Assistance: dfischer at usol.com **
>
>
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html
>
> ______________________________________________________________
> Ham-Computers mailing list
> Home: http://mailman.qth.net/mailman/listinfo/ham-computers
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:Ham-Computers at mailman.qth.net
>
> List Administrator: Duane Fischer, W8DBF
> ** For Assistance: dfischer at usol.com **
>
>
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html
>