Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
terrih
 
Posts: n/a
Default How do I do a random excel sort or shuffle, in no particular order

I want to create several teams with different people on each team. I want
there to be no particular order to the way I sort the teams and I want excel
to do this for me. Any suggestions?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pauwl
 
Posts: n/a
Default How do I do a random excel sort or shuffle, in no particular order

Terrih,

I would create a second column, with the formula =RAND() in each cell.
Then sort all columns chosing the new column as the first to sort by.

regards,

PauwlL

"terrih" wrote:

I want to create several teams with different people on each team. I want
there to be no particular order to the way I sort the teams and I want excel
to do this for me. Any suggestions?

  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default How do I do a random excel sort or shuffle, in no particular order

Put you list in column A and in column B enter =RAND() and copy down the
column.

Then sort A and B by B.

This will shuffle column A
--
Gary's Student


"terrih" wrote:

I want to create several teams with different people on each team. I want
there to be no particular order to the way I sort the teams and I want excel
to do this for me. Any suggestions?

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 save my 'sort criteria' in an Excel file? Jobod Excel Worksheet Functions 2 November 20th 05 05:06 AM
Can I create a random order within a series of numbers in Excel? Dimtrax Excel Worksheet Functions 2 November 9th 05 04:40 PM
Formula Integrity Not Preserved During Sort in Excel 2000 Kevin Excel Discussion (Misc queries) 1 April 15th 05 10:26 PM
how can i sort excel worksheets in alphabetical order? Birichica Excel Worksheet Functions 1 February 14th 05 07:25 PM
Excel Sort function should not sort the cell formatting! Lisa D.N.1 Excel Worksheet Functions 1 December 28th 04 09:37 PM


All times are GMT +1. The time now is 07:43 AM.

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

About Us

"It's about Microsoft Excel"