How can I sort a list of numbers by the last 4 digits?
 

I have a list of numbers that are 6 digits long & I want to sort them
(ascending or descending) by the last 4 digits. Is this possible?

How can I sort a list of numbers by the last 4 digits?
 

Using a helper column, it is.

Assume number is in cell A2 - A1000, say..

in helper column, enter =Right(A2,4)

Then sort based on the helper column...

"Kristin S" wrote:

I have a list of numbers that are 6 digits long & I want to sort them
(ascending or descending) by the last 4 digits. Is this possible?

How can I sort a list of numbers by the last 4 digits?
 

helper column

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Kristin S" <Kristin wrote in message
...
I have a list of numbers that are 6 digits long & I want to sort them
(ascending or descending) by the last 4 digits. Is this possible?

How can I sort a list of numbers by the last 4 digits?
 

Kristin,

One method is to insert a dummy column with formula =right(A1,4)
Then use the sort function to sort the dummy column in ascending or
descending order.
Please advise if this works.


Kristin S wrote:
I have a list of numbers that are 6 digits long & I want to sort them
(ascending or descending) by the last 4 digits. Is this possible?

--
Message posted via http://www.officekb.com