View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Anne Troy[_2_] Anne Troy[_2_] is offline
external usenet poster
 
Posts: 221
Default Sort Help for Excel

Hi, Seamlus. It's impossible to sort data by one column without "ruining"
another column's sort. Or don't I understand the question?
*******************
~Anne Troy

www.OfficeArticles.com


"Seamlus" wrote in message
oups.com...
Hey,

I'm need help sorting for excel. I have a list of vehicles by number
(1-300) and in the second column, I have their year (1984-2005) I need
to be able to sort the entire list from oldest year to newest year but
I can't seem to do that without changing their vehicle numbers.
Example, Truck #4 is a 2000 and Truck #5 is a 2000. If I sort by date,
Truck #4 because Truck #5. I want to keep the orginial numbers of the
truck while still organizing it by descending date. Thanks for your
help