Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 7th 08, 02:37 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 1
Default is it possible for excel to take several cells in random order and

im using microsoft excel 2002 and I'm wondering if its possible to take
several lines of data that all have the date in which they were entered in
column A, and arrange them on a separate sheet in the same work book so that
they are all in order by date?

  #2   Report Post  
Old January 7th 08, 03:17 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 20
Default is it possible for excel to take several cells in random order and

Select all data you want sorted (even the columns to the right or left that
you want to keep together with that row. Then choose data, then sort. Select
the column you want to sort by.

Good Luck.

"confused in Iowa" wrote:

im using microsoft excel 2002 and I'm wondering if its possible to take
several lines of data that all have the date in which they were entered in
column A, and arrange them on a separate sheet in the same work book so that
they are all in order by date?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I create and extract a random order from list in Excel? Michael Excel Discussion (Misc queries) 5 August 30th 07 08:02 AM
How can I sort a selection of cells into random order? IanS Excel Discussion (Misc queries) 2 June 14th 07 12:31 PM
How do I do a random excel sort or shuffle, in no particular order terrih Excel Discussion (Misc queries) 2 April 3rd 06 05:40 PM
list names in random order in Excel 2002 John Murf Excel Discussion (Misc queries) 2 February 25th 06 01:58 AM
Can you sort text in a random order in Excel tbowden Excel Discussion (Misc queries) 3 February 1st 05 02:42 PM


All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017