tricky sorting question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RobR - 19 Jan 2006 00:48 GMT

I need to sort all records by the last 4 digits in a particular column.
ie, my data looks like

alskjflkja0023
lkahsflkjf0021
mnslfkjas0019

I need to order all records by the last 4 digits. Any ideas on
how to go about doing that? All entries are 17 characters
long so it would be the right most 4 digits of the 17 character
string. Thanks!

Reply to this Message

Beege - 19 Jan 2006 01:09 GMT

RobR,

I suggest a helper column, with a formula like =RIGHT(A1,4)
Bring the formula down as far as needed, and sort on that column.

Beege

>I need to sort all records by the last 4 digits in a particular column.
> ie, my data looks like
[quoted text clipped - 7 lines]
> long so it would be the right most 4 digits of the 17 character
> string. Thanks!

Reply to this Message

RobR - 19 Jan 2006 02:56 GMT

Brilliant, worked perfectly. Thanks!

> RobR,
>
[quoted text clipped - 14 lines]
>> long so it would be the right most 4 digits of the 17 character
>> string. Thanks!

Reply to this Message

CLR - 19 Jan 2006 13:36 GMT

sIf this is something that you have to do frequently, you may be interested
in Jim Cone's fine commercial Add-in called "SpecialSort". It will do this
as a standard feature, along with many other types of sorts...........it'a
available at

http://www.realezsites.com/bus/primitivesoftware/

Vaya con Dios,
Chuck, CABGx3

> I need to sort all records by the last 4 digits in a particular column.
> ie, my data looks like
[quoted text clipped - 7 lines]
> long so it would be the right most 4 digits of the 17 character
> string. Thanks!

Reply to this Message