Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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? – Terry 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. – Terry Apr 10 '13 at 15:17
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, I double checked in XL2010 and it works fine. – dav Apr 10 '13 at 12:24

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .