View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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?