Thread: How can I sort a list of numbers by the last 4 digits?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chin via OfficeKB.com Chin via OfficeKB.com is offline
external usenet poster
  
Posts: 13
Default 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

Reply With QuoteReply With Quote