Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

is there anyway to randomize cels in excel?

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

is there anyway to randomize cels in excel?

Old 08-18-06, 01:10 PM
  #1  
DVD Talk Hall of Fame
Thread Starter
 
Join Date: Jun 2001
Posts: 7,770
Likes: 0
Received 0 Likes on 0 Posts
is there anyway to randomize cels in excel?

like if i fill in 10 different cels, is there a way i can mix them up into a random order?
Old 08-18-06, 01:13 PM
  #2  
Moderator
 
Groucho's Avatar
 
Join Date: Mar 2000
Location: Salt Lake City, Utah
Posts: 70,865
Likes: 0
Received 0 Likes on 0 Posts
I'm not sure what you're trying to do, but excel does have a random function (RAND()).

For instance, =(RAND()*100)+1 would produce a random # between 1 and 100.
Old 08-18-06, 02:40 PM
  #3  
Senior Member
 
Join Date: Sep 2002
Posts: 916
Likes: 0
Received 0 Likes on 0 Posts
lets say your ten items are in A1:A10. in B1:B10, enter =Rand(). then highlight all the 10 rows and sort by column b. not sure if excel seeds its rand() function
Old 08-18-06, 06:06 PM
  #4  
DVD Talk Hall of Fame
Thread Starter
 
Join Date: Jun 2001
Posts: 7,770
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by nodoubt
lets say your ten items are in A1:A10. in B1:B10, enter =Rand(). then highlight all the 10 rows and sort by column b. not sure if excel seeds its rand() function
that didnt work...kept giving me an error.
Old 08-18-06, 06:07 PM
  #5  
DVD Talk Hall of Fame
Thread Starter
 
Join Date: Jun 2001
Posts: 7,770
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by Groucho
I'm not sure what you're trying to do, but excel does have a random function (RAND()).

For instance, =(RAND()*100)+1 would produce a random # between 1 and 100.
thanks but not what i was looking for. want to randomize cels that already have stuff in them.
Old 08-18-06, 08:28 PM
  #6  
DVD Talk Hall of Fame
 
Join Date: Oct 1999
Location: not CT
Posts: 9,618
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by atari2600
thanks but not what i was looking for. want to randomize cels that already have stuff in them.
I think the point was that you would do this in cells adjacent to the ones already filled and then sort the group by the random column.
Old 08-19-06, 11:12 AM
  #7  
Member
 
Join Date: Apr 2000
Posts: 170
Likes: 0
Received 0 Likes on 0 Posts
Here's an example of what nodoubt suggested, along with a sample VBA macro: http://www.iansharpe.com/art_excel_random.php
Old 08-19-06, 12:44 PM
  #8  
Senior Member
 
Join Date: Sep 2002
Posts: 916
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by atari2600
that didnt work...kept giving me an error.
um dude u must have done something wrong. it works. look at kshan's link, the "How it's done" section to see what i suggested
Old 08-19-06, 03:31 PM
  #9  
DVD Talk Hall of Fame
Thread Starter
 
Join Date: Jun 2001
Posts: 7,770
Likes: 0
Received 0 Likes on 0 Posts
ill check it out. thanks.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.