Use string functions light RIGHT(<cell referenc>, 4) to produce a

derived column at the end of the block, and include it in the sort.

Remove when no longer needed.

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 2:22:37 PM >>>

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]