[Ham-Computers] SORTING CALLSIGNS WITH EXCEL

[Paul McInnish]

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