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!
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