need to sort list of numbers by last numbers

lostcda · Mar 3rd, 2002, 01:59 AM

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 · Mar 3rd, 2002, 02:09 AM

Quote:

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 · Mar 3rd, 2002, 02:55 AM

Thanks Aladin that worked for what i wanted.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 3rd, 2002, 01:59 AM	#1
lostcda New Member Join Date: Mar 2002 Posts: 2	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

Mar 3rd, 2002, 02:55 AM	#3
lostcda New Member Join Date: Mar 2002 Posts: 2	Thanks Aladin that worked for what i wanted.