You could try parsing the SSN into 2 columns.

The last four numbers in the second columns.

Then sort on that new column.

-----Original Message-----

From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com] On

Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI

Sent: Thursday, March 03, 2005 1:23 PM

To: profoxtech@leafe.com

Subject: RE: [NF] -- Excel sorting question

Thanks to all, it seemed pretty simple and I did the solution you all

suggested, showed the user how easy it was and then I got this question.

Now he wants to sort by the social security number (SSN column) but only

the last four. The menu driven way doesn't seem to have a substring

option -- I was hoping 'advanced options' would uncover something but it

didn't.

So, how do you do a partial column sort?

v/r

//SIGNED//

Stephen S. Wolfe, GS-11, DAFC

Data Services Manager

(813) 827-9972 DSN 651-9972

> -----Original Message-----

> From: Ray Heilman [mailto:RHEILMAN@mslc.com]

> Sent: Thursday, March 03, 2005 11:34 AM

> To: profox@leafe.com

> Subject: Re: [NF] -- Excel sorting question

>

> Position active cell in upper left corner of the data block.

>

> Menu, Data, Sort, set first key to 'organization' column, set

> second key to 'grade' column. Click OK.

>

> If you want the specific VBA for this, you can record the

> process as a macro and get the specifices of the sorting method.

>

> I hope this was what you meant! <g>

>

> Ray <><

>

> ------------------------------

> This email is intended for the use of the individual or

> entity to which it is addressed and may contain information

> that is privileged, confidential and exempt from disclosure

> under applicable law. If the reader of this email message is

> not the intended recipient, or the employee or agent

> responsible for delivery of the message to the intended

> recipient, you are hereby notified that any dissemination,

> distribution or copying of this communication is prohibited.

> If you have received this email in error, please notify us

> immediately by telephone at (502) 695-6870 or (888) 749-5799

> and also indicate the sender's name. Thank you.

>

>

> >>> Stephen.Wolfe@macdill.af.mil 3/3/2005 10:56:14 AM >>>

> For those who are Excel gurus ...

>

> I have a user that has a simple 7 column spreadsheet, nothing

> fancy and that individual Wants to have the spreadsheet

> maintain a two level sort. The first level on the 'organization'

> Column and the second level on the 'grade' column.

>

> How do you do that?

>

> TIA

>

> v/r

>

> //SIGNED//

> Stephen S. Wolfe, GS-11, DAFC

> Data Services Manager

> (813) 827-9972 DSN 651-9972

>

>

>

>

[excessive quoting removed by server]