Sort on last two digits of data
Hi Spike
If I had to write a macro for this task, it would work just as you
suggest to do manually.
Why not use column BD as helper column. Enter the formula below in
BD12 and copy it down to BD77.
=Right(A12,2)
Now select the entire table, sort on column BD, and hide the column
for future use. (You can sort on column BD even when it is hidden)
Hopes this helps.
....
Per
On 5 Feb., 18:51, Spike wrote:
A sorting question. *
I have a sheet of data A12:BC77. *I would like to sort this on items in
column A. *The problem is I need to order it by the last two digits of the
data in Column A. *So say ZWE11 will come before AA77 and QW22 will come
before BB55 and so on. *There is probably a simple answer but it is missing
me at the moment.
All I can think of is splitting out the last two digits into a new column
and sorting on that, then deleting that column once sorted but seems very
messy.
Any advice will be very gratefully received
--
with kind regards
Spike
|