Sort

[Kartal]

Hi All;
I have a column (say A) in which there are some alpha-numeric chracacters
like below:

300-YT-102
300-YT-342
300-YT-204
300-YT-894
300-YT-454
.....

I want to sort it according to the last 3 digit so that I will have;

300-YT-102
300-YT-204
300-YT-342
300-YT-454
300-YT-894
....

How can I do that?
Thanks

Kartal

 

[Bill Ridgeway]

You need a helper column in which there is the formula
=RIGHT(A1,3) if the remainder of ALL the entries in the column are 300-YT-
=RIGHT(A1,3)&A1 if the remainder of the entries in the column are not all
300-YT-

and sort on the helper column.

Regards.

Bill Ridgeway
Computer Solutions

 

[Kartal]

Thank you...

Kartal

You need a helper column in which there is the formula
=RIGHT(A1,3) if the remainder of ALL the entries in the column are
300-YT-
=RIGHT(A1,3)&A1 if the remainder of the entries in the column are not all
300-YT-

and sort on the helper column.

Regards.

Bill Ridgeway
Computer Solutions

 

[Guest]

Follow this link:

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

to a wonderful little add-in called "Special Sort" which offers a multitude
of sorting options far beyond those built into Excel.