need to sort list of numbers by last numbers

[lostcda]

I have a cvs file i download and i need to sort the entire sheet by only one column and have the rest of the data stay with each number.the numbers i need to sort consist of 7-10 digits but i need to sort them by there last 2 or 3 digits.

43649995
3673973
893690394
103713542
3700453
any help would be great

 

[Aladin Akyurek]

On 2002-03-03 00:59, lostcda wrote:
I have a cvs file i download and i need to sort the entire sheet by only one column and have the rest of the data stay with each number.the numbers i need to sort consist of 7-10 digits but i need to sort them by there last 2 or 3 digits.

43649995
3673973
893690394
103713542
3700453
any help would be great

Lets say that these numbers are in A and the data start in row 2.

Insert a new column left to A.

Enter in (new) A2: =RIGHT(B2,2)+0 [ copy down as far as needed ]

Select everything from row 2 on.

Sort on column A (using No header row).

 

[lostcda]

Thanks Aladin that worked for what i wanted.