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