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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • Looking fro right LOOKUP formula. Who is the formula expert???
    ... I have a list of values NOT in ascending or descending order. ... looking for a formula that looks for the first cell in the list above ... The Lookup formula ...
    (microsoft.public.excel)
  • Re: how to switch document list from zyx to abc order?
    ... Double clicking on the column header for 'Name' should reverse the direction. ... Upon opening "my documents" I discovered the file list reversed from ... ascending to descending order. ...
    (microsoft.public.word.docmanagement)
  • Re: integers into strings
    ... no im not converting the inputted number into a string im sorting the ... digits of the value into ascending and descending order and then making ...
    (comp.lang.ada)
  • Re: Stupid Newsreader Question
    ... That unthreads everything then just click on the Sent column to sort by date ... in ascending or descending order. ...
    (rec.pets.dogs.behavior)
  • Re: integers into strings
    ... seperate the digits then arrange it in ascending and descending order and subtract and ascending number from the descending number ... Jeff Carter "My name is Jim, but most people call me ... ...
    (comp.lang.ada)