How can I sort a list of numbers, by its last 3 digits in Excel

1

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!

Belgi

Posted 2013-04-10T09:24:51.847

Reputation: 735

Is VBA out of the question? – Terry – 2013-04-10T09:39:10.963

@djerry - what is VBA ? – Belgi – 2013-04-10T10:00:24.623

basically, VBA can solve your problem without having to add additional columns/data to your sheet. – Terry – 2013-04-10T15:17:46.137

Answers

7

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.

pnuts

Posted 2013-04-10T09:24:51.847

Reputation: 5 716

1+1, I double checked in XL2010 and it works fine. – dav – 2013-04-10T12:24:45.433

Asked: 2013-04-10T09:24:51.847

Viewed: 20 391 times

Active: 2013-04-10T09:46:59.217