Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jayyyyyy
 
Posts: n/a
Default Randomize rows in Excel?

How do I randomize rows in Excel?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default Randomize rows in Excel?

In an empty column, enter

=RAND()

and copy down as far as you need to go. Then, sort by that
column.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jayyyyyy" wrote in message
...
How do I randomize rows in Excel?



  #3   Report Post  
Posted to microsoft.public.excel.misc
David J. Braden
 
Posts: n/a
Default Randomize rows in Excel?

For a more dynamic approach, get the free addin PopTools.
HTH
Dave Braden

"Jayyyyyy" wrote in message
...
How do I randomize rows in Excel?



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
Deleting rows in a macro in Excel THEFALLGUY Excel Discussion (Misc queries) 4 December 23rd 05 01:59 PM
Rows & Columns in Excel seadragon69 Excel Worksheet Functions 2 December 7th 05 05:54 PM
How do I reduce number of Rows displayed in Excel worksheet? JerryRugs Setting up and Configuration of Excel 1 November 15th 05 07:55 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Can Excel "slide up" rows with content thru empty rows to condense portly44 Excel Worksheet Functions 2 April 1st 05 12:47 AM


All times are GMT +1. The time now is 10:14 PM.

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"