Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an Excel spreadsheet with a list of numbers in the first column (that is: I have a number in A_1,A_2,...).

Each one of the nubers if have 8-9 digits and I would like to sort this column by its last 3 digits (or create another column with the numbers sorted) (I would like that the last 3 digits of A_1 will be smaller or equal to those of A_2 etc')

Does anyone know of a way to do such a task ?

Note: I have Office 2010 installed.

Any help is greatly appreciated!

share|improve this question
    
Is VBA out of the question? –  Djerry Apr 10 '13 at 9:39
    
@djerry - what is VBA ? –  Belgi Apr 10 '13 at 10:00
    
Short for Visual Basic for Applications. See description for vba tag and/or Wikipedia –  pnuts Apr 10 '13 at 10:04
    
basically, VBA can solve your problem without having to add additional columns/data to your sheet. –  Djerry Apr 10 '13 at 15:17

1 Answer 1

up vote 6 down vote accepted

Based on xl2007 (but I doubt differs for Office 2010):

In B1 enter =RIGHT(A1,3) and copy down as required. Copy ColumnB and Paste / Special / Values over the top. Sort ColumnA:B AZ with Sort by ColumnB.

share|improve this answer
1  
+1, I double checked in XL2010 and it works fine. –  dav Apr 10 '13 at 12:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.